Home » RDBMS Server » Performance Tuning » Last Ananlyzed Column in OEM
Last Ananlyzed Column in OEM [message #198805] Wed, 18 October 2006 10:59 Go to next message
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 #198807 is a reply to message #198805] Wed, 18 October 2006 11:08 Go to previous messageGo to next message
magvivek
Messages: 2
Registered: September 2005
Junior Member
are you using analyze table instead of dbms_stats?
Re: Last Ananlyzed Column in OEM [message #198808 is a reply to message #198805] Wed, 18 October 2006 11:16 Go to previous messageGo to next message
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
is there a way to check it??
Re: Last Ananlyzed Column in OEM [message #198810 is a reply to message #198808] Wed, 18 October 2006 11:20 Go to previous message
Mahesh Rajendran
Messages: 10672
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

Previous Topic: Slow perfomance through satellite
Next Topic: library cache lock
Goto Forum:
  


Current Time: Sat Dec 10 17:04:47 CST 2016

Total time taken to generate the page: 0.10814 seconds