This discussion is archived
7 Replies Latest reply: Apr 1, 2013 10:27 AM by jgarry RSS

oracle performance

966684 Newbie
Currently Being Moderated
Hi All,

How to monitor the performance of the database/instance as a whole over a certain period of time. Using 10gR1 (10.1.0.4.0) on Oracle SE. OS is RHEL 5.6..

Say I'll be running some high load transactionas and queries over a certain period of time and want to capture the performance.
  • 1. Re: oracle performance
    sb92075 Guru
    Currently Being Moderated
    963681 wrote:
    Hi All,

    How to monitor the performance of the database/instance as a whole over a certain period of time. Using 10gR1 (10.1.0.4.0) on Oracle SE. OS is RHEL 5.6..

    Say I'll be running some high load transactionas and queries over a certain period of time and want to capture the performance.
    sar does a GREAT job of capturing overall system performance.
  • 2. Re: oracle performance
    Aman.... Oracle ACE
    Currently Being Moderated
    963681 wrote:
    Hi All,

    How to monitor the performance of the database/instance as a whole over a certain period of time. Using 10gR1 (10.1.0.4.0) on Oracle SE. OS is RHEL 5.6..

    Say I'll be running some high load transactionas and queries over a certain period of time and want to capture the performance.
    10.1 is loong time back got desupported and deprecated. So get the db upgraded to a supported release. 11.2 is very feature rich and is the supported release at the moment.

    For the monitoring of the performance, since you are on 10.1, all what you can do is to take a statspack report before and after the workload is executed and then compare the reports to find the delta.

    Aman....
  • 3. Re: oracle performance
    966684 Newbie
    Currently Being Moderated
    Hi ..this is on OS level, anything on DB level..
  • 4. Re: oracle performance
    Antonio Navarro Pro
    Currently Being Moderated
    Maybe grid control from Oracle or sar from Linux (very useful use a sar grapher like Ksar)

    HTH
    Antonio NAVARRO
  • 5. Re: oracle performance
    966684 Newbie
    Currently Being Moderated
    Hi,

    Using the OEM db console..don't have GRID control

    Was thinking on enabling a tracing at DB level..but never did earlier..will it help
  • 6. Re: oracle performance
    Aman.... Oracle ACE
    Currently Being Moderated
    963681 wrote:
    Hi,

    Using the OEM db console..don't have GRID control

    Was thinking on enabling a tracing at DB level..but never did earlier..will it help
    >
    Enabling tracing at db level will actually bring down the performance of the since it will be too much of the tracing and most likely, won't help either.

    Aman....
  • 7. Re: oracle performance
    jgarry Guru
    Currently Being Moderated
    http://jonathanlewis.wordpress.com/statspack-examples/ but ignore AWR or ASH references.

    Edit: Also google: cary millsap optimizing oracle for performance

    Edited by: jgarry on Apr 1, 2013 10:27 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points