How to identify IOPS in AWR reports

November 8, 2012 3 comments

The AWR reports are very usefull during the performance troubleshooting and also during proactive analysis.

One of the first steps in order to have apicture of the current environment is to know how are Oracle Database performance compared to the current hardware infrastructure.    The IOPS (Input/Output Operations Per Second) is one of the very interesting information to know before going deeper in the investigation.

The IOPS can tell you how many physical I/Os were executed in the last interval. If you see good performance then you can move forward in other directions.

Unfortunatelly you have to know what kind of hardware are available to the Database Server. Each different HW has different performances.

See below how to identifiy IOPS and MB/s from the AWR reports:


DBA Visual Board for Oracle, version 1.9.3 just released

October 27, 2012 Leave a comment

The new version of the DBA Visual Board for Oracle just released. This new version has new interface and now support Oracle 10g and above.

One of the most interesting feature is the “Database Visual Board”. Looking into this new interface you can quickly see lot of information regarding the current status of the database. There are 3 litle graphics and 3 grids in the same screen thus providing a visual look into the current running sessions, progress and resource utilization.

See below one sample screenshot:

To download and find additional documentation please go to my wiki page