Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Performance Statistics collection in Oracle

Re: Performance Statistics collection in Oracle

From: Ron Reidy <rereidy_at_indra.com>
Date: Wed, 17 Oct 2001 16:21:43 -0600
Message-ID: <3BCE0477.C8CA03D0@indra.com>


Eugene Zhang wrote:
>
> 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

Do you really work for Oracle? And you are asking this question here?

-- 
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.
Received on Wed Oct 17 2001 - 17:21:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US