Home » RDBMS Server » Performance Tuning » How heavy an AWR snapshot is (10g)
How heavy an AWR snapshot is [message #331276] Wed, 02 July 2008 18:07 Go to next message
lunaut
Messages: 6
Registered: July 2008
Junior Member
By default the snapshot interval is set to 10 minutes. I wish to set it to 1 minutes sometimes for various purpose, bu tworry about the overhead of te snapshot. Are there any data/metrics on that?

Thanks
Re: How heavy an AWR snapshot is [message #331277 is a reply to message #331276] Wed, 02 July 2008 18:19 Go to previous messageGo to next message
BlackSwan
Messages: 25032
Registered: January 2009
Location: SoCal
Senior Member
Go ahead & make the change to 1 minute.
You can always change it back.

As far as I know, for V10.2 the default interval is 30 minutes.
Re: How heavy an AWR snapshot is [message #331523 is a reply to message #331277] Thu, 03 July 2008 14:42 Go to previous messageGo to next message
lunaut
Messages: 6
Registered: July 2008
Junior Member
Thanks. But I need to monitor my production data warehouse in its peak hours early morning. I do not want it has observable impact on my production activity.

Re: How heavy an AWR snapshot is [message #331648 is a reply to message #331523] Fri, 04 July 2008 06:03 Go to previous message
alanm
Messages: 282
Registered: March 2005
Senior Member

hi,
what version database are you running on your datawharehouse?

regards

Alan

[Updated on: Thu, 17 July 2008 11:15] by Moderator

Report message to a moderator

Previous Topic: Problem sorting and inserting huge data (merged)
Next Topic: Oracle10g very slow on windows2003 server
Goto Forum:
  


Current Time: Fri Dec 02 12:04:59 CST 2016

Total time taken to generate the page: 0.05523 seconds