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