| Last Ananlyzed Column in OEM [message #198805] |
Wed, 18 October 2006 10:59  |
toshidas2000
Messages: 120
Registered: November 2005
|
Senior Member |
|
|
All
Please help me in this, I have a partition table ABC, when I see this table through OEM, Last Analyzed column shows 05-Dec-2005 03:21:05
While when I query dba_tab_partitions table, last analyzed column in this view for table ABC shows yesterday,
Why OEM has a different time stamp.
I am using Oracle 8i.
Thanks
Toshi
|
|
|
|
|
|
|
|
| Re: Last Ananlyzed Column in OEM [message #198810 is a reply to message #198808] |
Wed, 18 October 2006 11:20  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Not sure how we can find it precisely.
The major difference is dbms_stats will collect statistcs for individual partitions and the global statistics for the whole table.
Analayze will consider only the individual partition and derives the global stats from it.
[Updated on: Wed, 18 October 2006 11:30] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
