i need a script to run (give snapshot of database) on a daily basis since I am trying to tune my db. does anybody have a script which just gives me a snapshopt waits, latchest all in one?
I am making changes to sort area siez, block buffers, db_writers etc.
I have a utility that might be what you are looking for.
Take a look at EZSQL. [url]http://www.ezsql.net.[/url] It can be set up to perform monitoring. The results can be viewed as they are collected, or saved as a webpage, or sent via email. If there is some specific thing you want to monitor which is not there, send an email to email@example.com. I'll either add it in or give you a way to customize it.
Did you look into the Oracle's stats pack utility. A good detail description on how to use it had been provided in the oracle magazine site. Check that out. A small document is also available at $ORACLE_HOME/rdbms/admin/statspack.doc
Check that out.
Life is a journey, not a destination!
Click Here to Expand Forum to Full Width