| Doubt regarding automatic statistics collection in Oracle 10g [message #339761] |
Fri, 08 August 2008 06:54  |
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 #339772 is a reply to message #339768] |
Fri, 08 August 2008 07:43  |
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 ?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
