Full Table Scans Slower after Upgrade to 18.104.22.168 Due to an Increase in Disk Reads and Consequently Higher Waits on 'db file sequential read'
(Doc ID 2084790.1)
Last updated on FEBRUARY 18, 2019
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
- After upgrading to Rel. 188.8.131.52 from Rel. 184.108.40.206, a full table scan takes much longer, due to a higher number of disk reads.
The number of buffer gets (query column) has not changed, but the disk reads (disk column) have increased by approximately fifty percent. The execution plan is the same in each release.
Upgraded database from Rel. 220.127.116.11 to Rel. 18.104.22.168.
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