Re: SYSAUX tablespace

I checked this view and found that AWR occupies the 91%. Out of 25GB it occupied 91%. During the check, found that the defualt interval is 10 sec and thats the reason.

Can I remove the old records? Obviously the retention period is set to 30 days. Is this is recommeded ?

Thank you.

Brian Peasland wrote:
>> Hi,
>>
>[quoted text clipped - 10 lines]
>>
>> Thank You.
>
>Have a look at the V$SYSAUX_OCCUPANTS view. It will show you who is
>using what kind of space. Querying this view over time will give you an
>idea of where your space is growing. You can also query DBA_SEGMENTS too.
>
>You may or may not need this much space. It depends on who is hogging
>this space and how much space that really is.
>
>HTH,
>Brian
>

-- 
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums.aspx/oracle/200709/1