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: 208
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.

Report message to a moderator

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: 8960
Registered: January 2010
Location: Global Village
Senior Member
The view you want is v$sysaux_occupants.

Report message to a moderator

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: 208
Registered: October 2011
Senior Member
thanks, that is what I was looking for

Report message to a moderator

Previous Topic: How to create a database (Oracle 10g)
Next Topic: Identify sessions connected with Oracle connection Magager
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 28 22:00:18 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.