Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sysaux Tablespace full 95 Percentage...

568492May 17 2007 — edited May 17 2007

Hi,

I Have a tablespace call sysaux around 2GB.
The total tablespace is used around 1.9 GB and only 100 MB is free.
The 77 % of 1.9 GB is used to store AWR reports.
There are aound 4000 Awr report store in this table space...

I deleted around 3500 awr reports using drop_sanpshot.range option..

After droping this snapshot, still the status for Sysaux tablespaces used is around 1.9 GB.

system is not re-claiming the free disk space ...

What i can do to free up used sapce since, I have very less disk space on the disk itself ...

SSM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 14 2007

Added on May 17 2007

#general-database-discussions

1 comment

554 views