Performance Statistics collection in Oracle

From: Eugene Zhang <Eugene.Zhang_at_oracle.com>
Date: Wed, 17 Oct 2001 14:20:53 -0700
Message-ID: <WEmz7.147$78.25618@inet16.us.oracle.com>

Hi,

I am trying to generate a report for our application on the DB Server performance.

The report will be something like this:

                                         Avg
                        Actual        Target
Parameter        % Utilization % Utilization
---------------- ------------- -------------
BUFFER BUSY                  0            5%
CPU UTILIZATION             22           70%
DISK I/O                    32           70%
ENQUEUE WAITS                0            5%
LATCH CONTENTION             0           10%

             Average Maximum
------------ ------- -------
DB PROCESSES     163     170
DB SESSIONS       70      81

Does any one know whether these server statistics information are stored in any of the tables?

Thank you for you help in Advance!

Best Regards,
Eugene Received on Wed Oct 17 2001 - 16:20:53 CDT