OraFAQ Forum: Performance Tuning » How heavy an AWR snapshot is

Home » RDBMS Server » Performance Tuning » How heavy an AWR snapshot is (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How heavy an AWR snapshot is [message #331276]

Wed, 02 July 2008 18:07

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

Report message to a moderator

Re: How heavy an AWR snapshot is [message #331277 is a reply to message #331276]

Wed, 02 July 2008 18:19

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: How heavy an AWR snapshot is [message #331523 is a reply to message #331277]

Thu, 03 July 2008 14:42

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.

Report message to a moderator

Re: How heavy an AWR snapshot is [message #331648 is a reply to message #331523]

Fri, 04 July 2008 06:03

alanm
Messages: 284
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Aug 18 11:48:27 CDT 2025