Oracle Database - Input/Output (I/O)

Card Puncher Data Processing

About

physical io (on the drive) is aimed to seed the buffer cache where the logical io (database logical) occurs.

How to handle excessive I/O waits?

There are several ways to handle excessive I/O waits. In the order of effectiveness, these are as follows:

  • Reduce the I/O activity by SQL tuning
  • Reduce the need to do I/O by managing the workload (in the time)
  • Gather system statistics with DBMS_STATS package, allowing the query optimizer to accurately cost possible access paths that use full scans
  • Add more disks to reduce the number of I/Os for each disk
  • Alleviate I/O hot spots by redistributing I/O across existing disks

Documentation / Reference





Discover More
Card Puncher Data Processing
Oracle Database - ADDM (Automated Database Diagnostic Monitor) - Automatic Performance Diagnostics Tool

ADDM (Automated Database Diagnostic Monitor) is available since Oracle 10g. are useful features for performance tuning and troubleshooting. ADDM reports the most significant performance problems between...



Share this page:
Follow us:
Task Runner