DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Database Performance

  1. #1
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    151

    Question

    When you say DATABASE PERFORMANCE, what specific information do I have to look into to ensure that the Database is in good condition?

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Buffer cache hit ratio above 98%, library cache hit ratio and etc. You can make use of the Oracles statspack utility to know more information on performance tuning. There is an article on oracle magazine on how to use oracle statspac. Also this site too has technical docs on performance tuning check them too.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    151
    Sam,

    Aside from Buffer cache hit ratio, library cache hit ratio, Tablespace utilization. Is there anything else that you might want to add. The idea is to create a monitoring scripts that is going to run on a specified time interval using 'cron'. and once a certain threshold is reach the server will automiaticaly notify the DBA through e-mail or pager. My question now is What else is there to monitor to ensure that the database is performing well. For now Oracle, StatPack utility is out of the question.

    Thanks,

    Ed

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    There are number of other factors, like wait events, latch contentions,, buffer busy waits, i/o contentions, and etc. Why would you wnat to wast your time in sitting and writting the scrits, rather make use of the oracle tool OEM, where you can set events on the performance and then fire the message to the pager or to a mail box.

    I would suggest spend some time to set up the OEM and that would save a hell a lot of time and energy for you. :)

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Mar 2001
    Posts
    22

    Diagnosing Performance Using StatsPack

    There is a StatsPack for download from
    [url]http://technet.oracle.com/deploy/performance.[/url]

    The pack comes with tables and scripts to gather statistics.

    Once stats is gathered, report can be generated to look at the performance of the database.



    hptse

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