Database Administration (MOSC)

MOSC Banner

Tablespace SYSTEM&SYSAUX components size too large

edited Apr 25, 2023 2:48AM in Database Administration (MOSC) 2 commentsAnswered

My oracle version is 19.16 EE which is primary db using Data guard, recently first receive SYSAUX tablespace usage more than 90% and i checked and cleared Optimizer Expression Statistics Tracking data in highest tables SYS.EXP_HEAD$ & SYS.EXP_STAT$ around 60GB follow Doc ID 2354960.1,

however it is still growth quickly after 4 days. Maybe i can set "_column_tracking_level"=17 to disable the future as it is no impact to sql explain as it said in doc?

At the later time SYSTEM also trigger 90% usage alert and found the C_OBJ# CLUSTER size in SYSTEM is 26GB and increased 1G per day and now system tablespace size had achieve more than 30GB. I only found less information said C_OBJ# size is releate with db objects number, the db has 88272 objects, but another db's C_OBJ# size is 86MB which has 150066 objects. Not sure why this db's C_OBJ# is so big and increasing? Is there have way to reduce it or limit the increasing speed?

Tagged:

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