Home » RDBMS Server » Server Administration » Schema stats (Oracle 11gr2)
Schema stats [message #589754] Wed, 10 July 2013 08:30 Go to next message
suhasdba
Messages: 139
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
Re: Schema stats [message #589755 is a reply to message #589754] Wed, 10 July 2013 08:34 Go to previous messageGo to next message
BlackSwan
Messages: 22474
Registered: January 2009
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/
Re: Schema stats [message #589760 is a reply to message #589754] Wed, 10 July 2013 09:32 Go to previous messageGo to next message
Michel Cadot
Messages: 58489
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Schema stats [message #589800 is a reply to message #589760] Wed, 10 July 2013 23:58 Go to previous messageGo to next message
suhasdba
Messages: 139
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,
Re: Schema stats [message #589803 is a reply to message #589800] Thu, 11 July 2013 00:12 Go to previous messageGo to next message
Michel Cadot
Messages: 58489
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Schema stats [message #589845 is a reply to message #589803] Thu, 11 July 2013 06:40 Go to previous messageGo to next message
suhasdba
Messages: 139
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

Re: Schema stats [message #589848 is a reply to message #589845] Thu, 11 July 2013 06:54 Go to previous messageGo to next message
Michel Cadot
Messages: 58489
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, it is correct.

Regards
Michel
Re: Schema stats [message #589849 is a reply to message #589848] Thu, 11 July 2013 07:00 Go to previous message
suhasdba
Messages: 139
Registered: April 2013
Location: INDIA
Senior Member
Thank you very much Michel for your confirmation and detailed answers.

I am glad that i have learnt new things today Smile
Previous Topic: Synchronize data between two database.
Next Topic: Unused columns
Goto Forum:
  


Current Time: Tue Jul 22 16:40:19 CDT 2014

Total time taken to generate the page: 0.05613 seconds