Re: Measuring IOPS

IMHO the DB IO figures are reliable. But the y only picture what the DB can see, The OS sees everything, and there you can usually categorize by yourself, and don't have to rely on Oracle's predefined wait classes.

Maybe some IO benchmarking on the machine (with Oracle ORION or similar) can help to get absolute numbers to calculate offsets from.

Best regards
Martin Klier

Dba DBA schrieb:
> Martin,
> how reliable are the DB numbers? Another company has the operations
> contract so I don't get OEM access and they don't monitor performance. They
> basically do nuts and bolts (DB is up, backup recovery, call us if CPU gets
> too high), so I need to collect this myself. They only keep the AWR
> repository for 7 days, so I'm working on scripts to extract pieces of this
> to keep longer (want pieces to conserve space).
>
> is this even worth looking at? If its not reliable I won't bother. I don't
> get OS access which is how I used to monitor this stuff either and I won't
> get any support for this from operations (even if I gave them a script that
> monitored the OS and inserted records to a table).
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Usn's IT Blog for Linux, Oracle, Asterisk
http://www.usn-it.de

--
http://www.freelists.org/webpage/oracle-l