Can i know when the 'STATISTICS' was run on a Table ??? urgent plz

[Striker99]

All,

Hi everybody. I am relatively new to DBA activities. I was wondering is there any way i can know when was the last time 'compute statistics' was run on a particular table. I would like to get the time and date when it was last run. Is there any view i can get this information from.

My second question is, can i run compute statistics on a particular table while some other session(s) is updating the same table. I know there will be considerable decreace in the performance. I understand that stats may not be upto date with the latest updates. But can it be run simultaneously ???

Many thanks in advance,
striker99

 

[karluk]

There is a LAST_ANALYZED column in DBA_TABLES. As far as running statistics in the middle of another update, I would expect the impact to be fairly small. The analyze is a read only type of operation, except for a little updating of the catalog. Oracle is very good at handling this sort of simultaneous operation.

If you have to do the two simultaneously, I would say go ahead. Of course the ideal situation is to run statistics during a quiet period when nothing much is happening.

 

[THoey]

Also, if you use Oracle 8 and DBA Studio, you can look at the tables and it shows the last time statistics were run. Terry M. Hoey