Home » Server Options » RAC & Failsafe » Doubt regarding automatic statistics collection in Oracle 10g
Doubt regarding automatic statistics collection in Oracle 10g [message #339761] Fri, 08 August 2008 06:54 Go to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
I am using Oracle 10g in Linux

Does statistic collection for tables throughout the database happen automatically or should we manually analyze the tables using
Analyze command or DBMS_STATS package ?

AWR collects statistics(snapshots) every 1 hr but does it mean it collects only session and database related statistics and not the table related statistics?
Re: Doubt regarding automatic statistics collection in Oracle 10g [message #339768 is a reply to message #339761] Fri, 08 August 2008 07:16 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
check out the link

http://www.dba-oracle.com/art_dbazine_freeman_10g_advisors.htm
Re: Doubt regarding automatic statistics collection in Oracle 10g [message #339772 is a reply to message #339768] Fri, 08 August 2008 07:43 Go to previous messageGo to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
I am using Oracle 10g Standard edition (Oracle Database 10g Release 10.2.0.2.0 - 64bit Production) .

What I meant was snapshots collected by AWR contain information about the session related statistics and the wait events but does it also collect table statistics?
Since I checked the LAST_ANALYZED column of the tables and it showed it was a couple of months old .

Let me know if statistic collection is enabled in standard edition ?
Re: Doubt regarding automatic statistics collection in Oracle 10g [message #339774 is a reply to message #339772] Fri, 08 August 2008 07:50 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is this a RAC question?

Regards
Michel
Previous Topic: Failing over when database service is stopped
Next Topic: Real Application Cluster
Goto Forum:
  


Current Time: Thu Mar 28 14:28:10 CDT 2024