Hi,
I need to write a script to find out all the sys objects for which database already had statistics available(in unix).Can someone pls help? Thanks.
Hi,
Thanks for reply,I know how to write script in shell unix.My question is how to generate report for all the sys object for which database already had stat generated?Which V$ or DBMS package.Any ideas.Thanks
Hi,
I need to write a script to find out all the sys objects for which database already had statistics available(in unix).Can someone pls help? Thanks.
You can also do
execute dbms_stats.gather_system_stats('Start');
-- some time delay while the database is under a typical workload
execute dbms_stats.gather_system_stats('Stop');
you can query a table (owned by the SYS schema) called aux_stats$. After gathering system statistics,
I still don't see what Unix has to do with it. What difference would it make to stats what OS platform you were on? You might as well say "in Estonia".