How To Check the Usage of Active Undo Segments in AUM
(Doc ID 1337335.1)
Last updated on JULY 06, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.2 [Release 10.1 to 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database 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.
Goal
Sometimes, there are situations where the UNDO Tablespace starts growing unexpectedly.
So, how do you find out why?
Please note that the following queries only apply to Automatic Undo Management (AUM) where UNDO_MANAGEMENT is set to AUTO.
Solution
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
| Goal |
| Solution |
| References |