Home » RDBMS Server » Server Administration » Collect object stats (Oracle 11.2.0.3 ,Linux 5)
Collect object stats [message #594509] Thu, 29 August 2013 06:00 Go to next message
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
Re: Collect object stats [message #594512 is a reply to message #594509] Thu, 29 August 2013 06:43 Go to previous messageGo to next message
Michel Cadot
Messages: 60063
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Collect object stats [message #594515 is a reply to message #594509] Thu, 29 August 2013 06:59 Go to previous messageGo to next message
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 ..? -
Re: Collect object stats [message #594533 is a reply to message #594515] Thu, 29 August 2013 10:57 Go to previous messageGo to next message
Michel Cadot
Messages: 60063
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
How you are collecting stats on daily basis..?


This is said in the first sentence (the quote) of OP's post.

Regards
Michel
Re: Collect object stats [message #594620 is a reply to message #594533] Sat, 31 August 2013 03:10 Go to previous message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Hi Michel/Sarat,

I will follow your guidance.

Thanks
Previous Topic: New features in Oracle 11.2.0.4
Next Topic: number of connection for a user
Goto Forum:
  


Current Time: Sun Dec 28 21:15:59 CST 2014

Total time taken to generate the page: 0.07112 seconds