Query Against DBA_FREE_SPACE is Slow After Applying 11.2.0.4
(Doc ID 1904677.1)
Last updated on MARCH 03, 2022
Applies to:
Oracle Database Cloud Service - Version N/A and laterOracle Database - Enterprise Edition - Version 11.2.0.4 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Information in this document applies to any platform.
Symptoms
- Some queries against the dba_free_space view perform slowly after applying the 11.2.0.4 patchset
- The access path for the query shows that it performs a Full Table Scan (FTS) against the fixed table X$KTFBUE:
does not help. - Emptying the recycle bin (RECYCLEBIN$) does not help either
Changes
Applied the 11.2.0.4 patch set.
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 |