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


×