Dear DBAs,
I have disabled the SM/AWR and SM/OPTSTAT. But still SYSAUX is
growing. Can anyone help me to find out why it is still growing
select SNAP_INTERVAL,RETENTION,TOPNSQL from DBA_HIST_WR_CONTROL;
SNAP_INTERVAL RETENTION TOPNSQL
+40150 00:00:00.000000 +01 00:00:00.000000 30
SELECT occupant_name, space_usage_kbytes FROM V$SYSAUX_OCCUPANTS;
OCCUPANT_NAME SPACE_USAGE_KBYTES
SM/AWR 829,760
SM/OPTSTAT 498,816
Best Regards,
M.Moovarkku Mudhalvan
----------------------------------------
E-mail disclaimer:
This message is confidential; its contents do not constitute a
commitment by AXA NON-LIFE INSURANCE CO LTD except where provided for in
a written agreement between you and the Company. Any unauthorized
disclosure, use or dissemination, either whole or partial, is
prohibited. If you are not the intended recipient of this message,
please notify the sender immediately.
----------------------------------------
