7 Replies Latest reply: Apr 1, 2013 12:27 PM by jgarry RSS

    oracle performance

    966684
      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
          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....
            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
              Hi ..this is on OS level, anything on DB level..
              • 4. Re: oracle performance
                Antonio Navarro
                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
                  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....
                    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
                      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