-
Hello
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.
thanks
Jig
-
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 john@ezsql.net. I'll either add it in or give you a way to customize it.
-John
-
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.
Sam
Thanx
Sam
Life is a journey, not a destination!
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
|