My Oracle Support Banner

Troubleshooting high direct path read/write temp waits on Exadata (Doc ID 2625293.1)

Last updated on JANUARY 25, 2020

Applies to:

Exadata X6-2 Hardware - Version All Versions and later
Exadata Database Machine X8-2/X8M-2 Hardware - Version All Versions and later
Oracle Exadata Storage Server Software - Version 12.2.1.1.0 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Exadata X7-2 Hardware - Version All Versions and later
Information in this document applies to any platform.

Goal

Running SQLs with large sort and join operations can result in direct path read/write temp waits, this happens when the database FG process PGA is inadequate to handle the join/sort operations and gets spill over to the temporary tablespaces. This can degrade the performance of batch jobs or applications. There are also cases when the direct path read/write IO waits increases over time due to workload pattern changes, affecting the SQL performance.

The goal of this document to share the troubleshooting techniques to optimize the direct path read/write temp waits on Exadata.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.