Results 1 to 3 of 3

Thread: last analyzed

  1. #1
    Join Date
    Nov 2014
    Posts
    13

    last analyzed

    Hi My Friends
    when I navigate oracle enterprise manager and going to schema and TABLES I seeing last column header is 'LAST ANALYZED' and for every table a individual date is inserted, my question:
    which process or job analyze the tables?
    why the dates are not equal and are different?
    thanks

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    DBMS_STAT package or ANALYZE command update that column. You need to check if you have any scheduled job or maintenance plan defined.

  3. #3
    Join Date
    Nov 2014
    Posts
    13
    thanks for your help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •