Thursday 21 March 2019

STATS Collection Oracle SQL Query


Here is the Sample Oracle SQL Query for the STATS collection.


select t.last_analyzed, nvl(num_rows,0) num_rows, t.* from all_tables t where last_analyzed is not null and owner in (<Oracle_Schema_name>)
order by 1 desc;

No comments:

Post a Comment