Home » RDBMS Server » Server Administration » changing awr retention (space used) (Oracle 11.2.0.3.8)
changing awr retention (space used) [message #610107] Mon, 17 March 2014 12:30 Go to next message
BeefStu
Messages: 192
Registered: October 2011
Senior Member
I am currently collecting AWR snapshots once an hour and keeping them for 7 days.
I am interested in changing the collection interval from 1 hr to every 15 minutes. I am guessing this will take up 4X amount of space?

Is there some way to verify this and see how much space the snap shots are
taking up currently at my default settings? A query would be very helpful.


Thanks in advance to all who answer.
Re: changing awr retention (space used) [message #610110 is a reply to message #610107] Mon, 17 March 2014 12:34 Go to previous messageGo to next message
John Watson
Messages: 4569
Registered: January 2010
Location: Global Village
Senior Member
The view you want is v$sysaux_occupants.
Re: changing awr retention (space used) [message #610111 is a reply to message #610110] Mon, 17 March 2014 12:49 Go to previous message
BeefStu
Messages: 192
Registered: October 2011
Senior Member
thanks, that is what I was looking for
Previous Topic: How to create a database (Oracle 10g)
Next Topic: Identify sessions connected with Oracle connection Magager
Goto Forum:
  


Current Time: Sun Sep 21 07:40:36 CDT 2014

Total time taken to generate the page: 0.05142 seconds