Oracle Applications
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment