Analyze table takes very long time - Page 3
DBAsupport.com Forums - Powered by vBulletin
Page 3 of 3 FirstFirst 123
Results 21 to 22 of 22

Thread: Analyze table takes very long time

  1. #21
    Join Date
    Dec 2001
    Posts
    141
    Originally posted by Giani
    Also Did you analyze you latest index created? if you don't that might be your problem.
    check if somebody created an index recently :
    select OWNER,OBJECT_NAME,OBJECT_TYPE,CREATED,LAST_DDL_TIME,STATUS
    from dba_objects
    where created=(select max(created) from dba_objects) ;
    You're right Giani, there are indexes latest created.
    The table analyzed was :
    first truncated,
    then inserted,
    analyzed (compute),
    then indexes were created,
    and finally the table was analyzed again (compute).

    The number of rows in the table is constant and wasn't growing.
    I still don't understand why the analyzed takes such a long time ...
    Any idea ?
    Thanks a lot for all your advices !

  2. #22
    Join Date
    Dec 2001
    Posts
    141
    Another precision ...
    I've exported the table and its indexes on another database but in 8.1.7 release.
    The analyze statement on the new database takes only 8 minutes ...

Posting Permissions

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


Click Here to Expand Forum to Full Width