Database Administration (MOSC)

MOSC Banner

SYSAUX usage is growing

edited Aug 14, 2020 5:02PM in Database Administration (MOSC) 5 commentsAnswered

I check that the condition SYSAUX growing cause this condition:

- SM/ADVISOR

- SM/OPTSTAT

- SM/AWR

This occupant size always growing.

I try to running this script to reduce ADVISOR and it works.

BEGIN  
  DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETER (  
  task_name => 'AUTO_STATS_ADVISOR_TASK'  
  , parameter => 'EXECUTION_DAYS_TO_EXPIRE'  
  , value => 31  
  );  
  END;  
  /

The status of SM/ADVISOR is stable "not growing".

But I have different condition for another occupant:

1. SM/AWR -> still growing

2. SM/OPTSTAT -> still growing

With this condition, our SYSAUX tablespace still growing. Could you give us the advice to do reduce this occupant?

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