Performance analysis of the HP Serviceguard Storage Management Suite for Oracle Database

• db_file_sequential_read wait time, the time a user process is waiting for a single physical I/O call
to return when reading buffers into the Oracle System Global Area (SGA).
• logfile sync time, the time a user process is waiting for the log writer to finish flushing the log buffer
to disk. This occurs when a user commits a transaction (a transaction is not considered committed
until all of the redo to recover the transaction has been successfully written to disk).
• log file parallel write wait time, time it takes for the I/Os to complete. Even though redo records are
written in parallel, the parallel write is not complete until the last I/O is on disk.
• average receive time for CR block, the total time required for consistent read requests to complete
(consistent means a read for a data block that is not in its local cache, it sends a request to another
instance). It records the accumulated round-trip time for all requests for consistent read blocks.
• CPU consumption (idle time %)
• network utilization at IP (interconnect traffic) and DLPI (CFS unicast traffic) levels.
Test topology
Hardware
Figure 1 shows a detailed architectural diagram of the test bed.
Figure 1. Architectural diagram of test bed
4