rapid growth for sysaux tablespace
From: Mostafa Eletriby <m_etrib_at_yahoo.com>
Date: Thu, 30 Oct 2014 07:54:04 -0700
Message-ID: <1414680844.80401.YahooMailNeo_at_web162403.mail.bf1.yahoo.com>
Dear All,
Please I have a problem regarding sysaux tablespace. it is a database for BI & I need to purge unused space at sysaux & all other tablespaces if needed. to free unused space. I checked these options but didn't start them yet. what are the procedures that I should follow in such case, as data are very sensitive.
Date: Thu, 30 Oct 2014 07:54:04 -0700
Message-ID: <1414680844.80401.YahooMailNeo_at_web162403.mail.bf1.yahoo.com>
Dear All,
Please I have a problem regarding sysaux tablespace. it is a database for BI & I need to purge unused space at sysaux & all other tablespaces if needed. to free unused space. I checked these options but didn't start them yet. what are the procedures that I should follow in such case, as data are very sensitive.
alter table xxx deallocate unused space; alter index xxx deallocate unused space;
alter table xxx coalesce;
alter index xxx coalesce;
Now I started to run
exec dbms_stats.purge_stats(sysdate-4);
It takes 2 days & still running.
DB Version: 11.2.0.2 Enterprise Edition
DB size: about 500 GB
O.S: Windows 2008 Enterprise Edition R2 64 Bit
Please check & advice.
Thanks
Regards,
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 30 2014 - 15:54:04 CET