High Direct Path Read I/O After Patching DB to 19.18 RU on Non-Exadata Systems
(Doc ID 2947314.1)
Last updated on MAY 21, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 19.18.0.0.0 to 19.18.0.0.0 [Release 19]Information in this document applies to any platform.
Symptoms
After patching database with 19.18DBRU patch, high "direct path read" is observed for SQL statements which previously used buffer cache reads.
You will likely see the same execution plan, but more physical IO per SQL ID for such operations due to blocks going to PGA over and over again causing high Physical Reads in the database.
Changes
Database Patching to 19.18 DBRU
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |