Re: Oracle 10g Rel2 - SYSMAN Tablespace Growing
Look at the indexes in for the AWR tables. They grow and never shrink in 10. You will have to write a simple procedure to rebuild or coalesce them on a regular basis. 



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.
----------------------------------------






--
http://www.freelists.org/webpage/oracle-l

Other related posts: