OraFAQ Forum: Server Administration » Collect object stats

Home » RDBMS Server » Server Administration » Collect object stats (Oracle 11.2.0.3 ,Linux 5)

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

Collect object stats [message #594509]

Thu, 29 August 2013 06:00

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Hi,

Quote:

Oracle collects new statistics when enough of the data (about 10%) has changed.

I read the above statement in the oracle documentation that Oracle collects new statistics when
enough of the data (about 10%) has changed every day during 10 pm to 6am .

But still i see some object statistics are stale and empty.Do i need to collect statistics for these objects manually ?
and would like to know why these objects statistics were not collected during maintenance window ?

Thanks

Report message to a moderator

Re: Collect object stats [message #594512 is a reply to message #594509]

Thu, 29 August 2013 06:43

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

Senior Member
Account Moderator

Quote:

I read the above statement in the oracle documentation

ALWAYS post the link to what you quote.

Quote:

But still i see some object statistics are stale and empty.

Post evidence you see that.
Maybe the job is deactivated.

Regards
Michel

Report message to a moderator

Re: Collect object stats [message #594515 is a reply to message #594509]

Thu, 29 August 2013 06:59

pvsarat
Messages: 10
Registered: October 2012
Location: CHENNAI

Junior Member

How you are collecting stats on daily basis..? - I mean any cronjob is running to collects the stats on daily..? - If yes you need see the job why it is not triggered ..? -

Report message to a moderator