My Oracle Support Banner

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

Last updated on NOVEMBER 01, 2021

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 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.


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.


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

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