Need monitoring script
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Need monitoring script

  1. #1
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    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

  2. #2
    Join Date
    Nov 2000
    Posts
    344
    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

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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
  •  



Click Here to Expand Forum to Full Width