Database Administration (MOSC)

MOSC Banner

drop/recreate awr repository to reclaim space.

edited Nov 4, 2009 7:23AM in Database Administration (MOSC) 6 commentsAnswered
I am having a problem with the SYSAUX tablespace filling.  I am running on Solaris with ORACLE 10.2.0.3.  I have already changed the retention period for the AWR snapshots to 7 days and purged all older snapshots.  We take snapshots every 30 mins.

It still seems that the AWR repository is using almost 10G of space(as seen from the V$sysaux_occupants table). 

OCCUPANT_NAME                                                      Space (M)
---------------------------------------------------------------- -----------
SCHEMA_NAME
----------------------------------------------------------------
MOVE_PROCEDURE
----------------------------------------------------------------
SYS


SM/AWR                                                              9,828.00
SYS

At this point I would be very happy to just drop and recreate the repository.  I have found conflicting information on how to do this.  All sources seem to say to run  @?/rdbms/admin/catnoawr.sql to drop it, but to recreate   one source says to run @?/rdbms/admin/catsvrm.sql and one says to run catawrtb.sql.  I notice that the first script calls the second and does a lot more.  Can someone tell me how to do this..

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center