granularity => 'ALL' for DBMS_STATS
http://oracleexamples.wordpress.com/2009/09/16/tips-for-dbms_stats-part-22/
rowlen surprise
-
Here’s a little detail about Oracle’s calculation of
user_tables.avg_row_len that I hadn’t noticed before – and I really should
have noticed it years ago, ...
Acum o săptămână
Niciun comentariu:
Trimiteți un comentariu