Re: SYSAUX tablespace

Thanks Mark ! I have reset the interval to 60 sec from 10 sec.

BTW you mean AWR will occupy 300M for every 10 sessions. Its very high rate !!

Ravi

Mark D Powell wrote:
>> > Hi,
>>
>[quoted text clipped - 36 lines]
>>
>> - Show quoted text -
>
>Ravi, you did not specifiy the file size. I think Oracle estimates
>that the AWR snaptshots will take 200 - 300M for every 10 sessions to
>hold the default 7 days of snapshots taken by default at one hour
>intervals.
>
>You can change both these intervals to reduce the amount of data
>retained.
>
>Oracle should automatically begin overwriting snapshots if it runs
>short of free space in the SYSAUX tablespace.
>
>See dbms_workload_repository.modify_snapshot_settings(
>retention => seconds, interval >= 60, dbid = x)
>
>HTH -- Mark D Powell --

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