SYSAUX Tablespace Occupies More Space When Database is Upgraded from 11g to 12c Compared to New Database Created in 12c
(Doc ID 2345496.1)
Last updated on DECEMBER 24, 2023
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata Express Cloud 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 Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
- Databases upgraded from 11g to 12c .. SYSAUX tablespace occupies around 50% more space in 12c post database upgrade
- Awrinfo.sql shows following object taking most space:
| Occupant Name Schema Name Space Usage| -------------------- -------------------- ----------------
| SM/OPTSTAT SYS 840.5 MB
| SM/AWR SYS 342.1 MB
| SM/OTHER SYS 99.2 MB
| XDB XDB 62.1 MB
| SM/ADVISOR SYS 30.3 MB
| JOB_SCHEDULER SYS 15.4 MB
| LOGMNR SYSTEM 14.6 MB
COMPONENT MB SEGMENT_NAME SEGMENT_TYPE
--------- --------- --------------------------------------------------------------------- ---------------
NON_AWR 315.0 SYS.I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST INDEX
NON_AWR 160.0 SYS.I_WRI$_OPTSTAT_H_ST INDEX
NON_AWR 88.2 SYS.SYS_LOB0000006421C00005$$ LOBSEGMENT
NON_AWR 41.0 SYS.I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST INDEX
NON_AWR 19.0 SYS.I_WRI$_OPTSTAT_HH_ST INDEX
Changes
Database upgraded from 11g to 12c.
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 |