OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Schema stats (Oracle 11gr2)

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

Schema stats [message #589754]

Wed, 10 July 2013 08:30

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Hi,

Can we gather statistics for schema at any working time or is there any maintenance time for?

Regards,
Suhas

Report message to a moderator

Re: Schema stats [message #589755 is a reply to message #589754]

Wed, 10 July 2013 08:34

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Can we gather statistics for schema at any working time or is there any maintenance time for?
I give up. Can you?
Do you have a maintenance window?

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Schema stats [message #589760 is a reply to message #589754]

Wed, 10 July 2013 09:32

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Gathering statistics consume resources, invalid current cursors, and may lead to changes in execution plans.

Now it's up to you.

Regards
Michel

Report message to a moderator

Re: Schema stats [message #589800 is a reply to message #589760]

Wed, 10 July 2013 23:58

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Hi Michel,

Quote:

Gathering statistics consume resources, invalid current cursors, and may lead to changes in execution plans.

Based on your answer , i plan to gather statistics during maintenance window.

But what is maintenance window.Could you give more details on it so that it will be be helpful
for me to decide whether to run it during that time or not.

Regards,

Report message to a moderator

Re: Schema stats [message #589803 is a reply to message #589800]

Thu, 11 July 2013 00:12

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

A maintenance window is a period when the applications don't work and you are free to use the database as you want.

Regards
Michel

Report message to a moderator

Re: Schema stats [message #589845 is a reply to message #589803]

Thu, 11 July 2013 06:40

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Quote:

A maintenance window is a period when the applications don't work and you are free to use the database as you want.

Thanks for the definitions.

So i believe maintenance window is the best time to gather schema stats in database .So that there wont be any mislead in execution plans and resources consumption etc..

Michel,

Is my understanding is correct ?

Regards,

[Updated on: Thu, 11 July 2013 06:42]

Report message to a moderator