High Cell Single Block Physical Read Causes Query Performance Downgrade on XT
(Doc ID 2753761.1)
Last updated on JULY 18, 2023
Applies to:
Oracle Exadata Storage Server Software - Version 19.3.9.0.0 to 20.1.7.0.0 [Release 12.2 to 20.0]Information in this document applies to any platform.
Symptoms
The select query has performance issue, the main wait is due to 'cell single block physical read'fromthe awr reports. Seems like the smart scan does not work properly.
Changes
The query is compared between XT and HC. The two dbs have every parameter, work load the same. I see the same plan with different amount of rows on both dbs. Flash is not included on XT. The same query on XT takes 47 sec to finish and it takes 9 sec on HC.
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 |