rapid growth for sysaux tablespace
- From: "Mostafa Eletriby" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "m_etrib@xxxxxxxxx" for DMARC)
- To: oracle apps DBA group <oracle-l@xxxxxxxxxxxxx>, DB group <oracle-tips@xxxxxxxxxxxxx>
- Date: Thu, 30 Oct 2014 07:54:04 -0700
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,
Other related posts:
