Register Login

Last time Update Statistics

Updated May 18, 2018

Hi Gurus,

Can anybody please let me know how to find out when were the optimizer statics updated last time ?

Comments

07 Jan 2013 6:48 pm Prasad Best Answer
Last Analyzed Tables
SELECT
OWNER,
TABLE_NAME,
NUM_ROWS,
SAMPLE_SIZE,
TO_CHAR(LAST_ANALYZED, 'dd.mm.yyyy hh24:mi:ss') LAST_ANALYZED,
TO_CHAR(LAST_ANALYZED, 'yyyy') LAST_ANALYZED_YEAR
FROM
DBA_TABLES;

Prasad Pithani

28 Feb 2014 1:41 pm Guest Helpful Answer

You can check the status in transaction DB24

17 Apr 2009 11:35 am Guest

Hi,

Check in DB20 for individual tables, and check in DB21 for all.

Regards

17 Apr 2009 11:35 am Guest

Use tcode DB14..
you`ll find out there your update statistics optimizer log (if you have runit)...

17 Apr 2009 11:35 am Guest

check db16 susi

Recommended Posts:

×