SYSAUX usage is growing
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?