How to verify if system stats were collected
I was wondering if there is a way to check and verify if the following were run successfully in a database.
Appreciate your help
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
There are no logs. The commands were executed a couple of weeks ago. I need to ensure if it was really run and if it was successfull.
First of all, those commands are executed everyday at 10:00 PM and 6:00AM as default. If you change that period, you can check the values on dictionary statistics views start with dba#, all# or user#. For this comparison, you must have the older values which were gotten before those commands were executed.
By the way, why do you have doubts for those commands?
Try querying DBA_OPTSTAT_OPERATIONS
Click Here to Expand Forum to Full Width