|
-
How to verify if system stats were collected
Hi,
I was wondering if there is a way to check and verify if the following were run successfully in a database.
execute dbms_stats.gather_system_stats;
execute dbms_stats.gather_dictionary_stats;
execute dbms_stats.gather_fixed_objects_stats;
Oracle -10.2.0.2
Appreciate your help
Regards
Jay
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|