Large Growth of SYSAUX Tablespace with Table WRH$_SQL_PLAN Taking Lot of Space
(Doc ID 2475149.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
- Large growth of SYSAUX tablespace
- Table WRH$_SQL_PLAN grows to more than 1,000,000 MB
- Manual purging using DBMS_WORKLOAD_REPOSITORY.PURGE_SQL_DETAILS also does not
purge WRH$_SQL_PLAN - There are 2 dbid's in repository:
select min(BEGIN_INTERVAL_TIME),dbid from dba_hist_snapshot group by dbid ;
MIN(BEGIN_INTERVAL_TIME) DBID
---------------------------------------------------------------- ----------
14-DEC-17 04.02.34.000 AM 4051164
10-JUN-15 02.30.09.015 AM 3126481
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 |
| Cause |
| Solution |
| References |