Re: Performance Statistics collection in Oracle

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

Check out statspack - a lot of the work is done for you...Other than that, look the V$ views for info, for example,

v$sysstat
v$resource_limit
v$system_event

et al.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."