OraFAQ Forum: Server Administration » Refreshing the Stale Statistics in Oracle Database

Home » RDBMS Server » Server Administration » Refreshing the Stale Statistics in Oracle Database

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

Refreshing the Stale Statistics in Oracle Database [message #452313]

Wed, 21 April 2010 04:53

gururajster
Messages: 26
Registered: October 2006
Location: bangalorre

Junior Member

Hi All,

Can anyone please let me know the importance of refreshing the stale statistics in oracle database and also how often we should do this?.Thanks in advance for any help.

-KR

Guru

Report message to a moderator

Re: Refreshing the Stale Statistics in Oracle Database [message #452314 is a reply to message #452313]

Wed, 21 April 2010 04:58

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Oracle generates its plan from the statistics, if the statistics are wrong then the plan are not optimal and performances bad.
If you are in 10g and up, let Oracle does it itself.

Regards
Michel

Report message to a moderator

Re: Refreshing the Stale Statistics in Oracle Database [message #452323 is a reply to message #452314]

Wed, 21 April 2010 05:41

gururajster
Messages: 26
Registered: October 2006
Location: bangalorre

Junior Member

Hi Michel,

Many thanks for the reply Smile

Any idea how often oracle 10g and above will refresh the stale statistics.

-KR
Guru

Report message to a moderator

Re: Refreshing the Stale Statistics in Oracle Database [message #452324 is a reply to message #452313]

Wed, 21 April 2010 05:42

cookiemonster
Messages: 13923
Registered: September 2008
Location: Rainy Manchester

Senior Member

There's an automatic scheduled job that runs every night.

Report message to a moderator

Previous Topic:	Size of the Oracle database 11g
Next Topic:	Calculation of initial extent size of table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 23 08:06:53 CDT 2024