My Oracle Support Banner

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


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