Archive

Archive for September, 2014

When tables where last analyzed in a schema

September 17, 2014 Leave a comment

When tables where last analyzed in a schema

SQL> select TABLE_NAME, LAST_ANALYZED,num_rows,sample_size from DBA_TAB_STATISTICS where OWNER=’TRCASIT;

Also, shows sample size and number of rows

Advertisements
Categories: Uncategorized