Re: rapid growth for sysaux tablespace

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Thu, 30 Oct 2014 10:08:47 -0500
Message-ID: <CAP79kiRe59a1A_Xt78dHEDPz2ZZiFneWcL8gyMp-xZqOzCobmw_at_mail.gmail.com>

​I'd check to see what segment(s) are consuming space in SYSAUX and then cross reference those objects in Oracle Support to see if there are known issues and workarounds/solutions.

select owner, segment_name, bytes/1024/1024 as size_mbs from dba_segments
where tablespace_name = 'SYSAUX'
order by bytes desc
/

Then cross reference those objects in Oracle support...

Chris
​

On Thu, Oct 30, 2014 at 9:54 AM, Mostafa Eletriby < dmarc-noreply_at_freelists.org> wrote:

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

Received on Thu Oct 30 2014 - 16:08:47 CET