Chat now with support
Chat with Support

Spotlight on Oracle 10.7 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

Disk Latency And Disk Throughput

To represent disk utilization, Predictive Diagnostics employs the metrics disk latency and disk throughput. Choose whichever suits your environment best.

Option Description

Disk latency

The average time taken to perform a disk I/O operation.

Disk latency often reflects a user's perception of system performance. It is a good indicator of resource utilization when your system is used mainly for online transaction processing (OLTP).

Disk throughput

The average rate of I/O operations.

Throughput is a good indicator of resource utilization when used to diagnose systems with a high rate of I/O operations, such as batch processing systems.

High throughput does not affect disk performance until the workload causes queuing, at which point system performance can degrade rapidly and substantially. You can provide advance warning of this by using Predictive Diagnostics to set an appropriate Database Resource Ceilings.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating