Database Administration (MOSC)

MOSC Banner

SQLOBJ$PLAN table / SYSAUX growing out of bounds

Hello

We have a 19.13.0.0.0 database on our production exadata machines

The SYSAUX tablespace has grown a lot of late

The table SQLOBJ$PLAN table is 147 GB (93 GB LOB and 54 GB Data) and an index on it is 7.4 GB so a total of 154 GB

select sum(bytes)/1024/1024/1024 GB from dba_Segments where segment_name='SYS_LOB0018907224C00040$$';

GB 

93.24

select sum(bytes)/1024/1024/1024 GB from dba_Segments where segment_name='SQLOBJ$PLAN';

GB

54.43

SQL> select sum(bytes)/1024/1024/1024 GB from dba_Segments where segment_type like '%INDEX%' and segment_name in

 2 (select index_name from dba_indexes where table_name='SQLOBJ$PLAN');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center