Analyze Index (validate Structure)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Analyze Index (validate Structure)

Hybrid View

  1. #1
    Join Date
    Jul 2001
    Posts
    108

    Question Analyze Index (validate Structure)

    Hello,

    I have a table, which has more than 20 million records. When I am trying to validate the structure related to this large table, the process is taking really long time.

    ANALYZE INDEX "INDEX_NAME" VALIDATE STRUCTURE;

    Is there an option to use parallel processing to improve the processing speed? If not please let me know other options.

    Thanks,
    Nikee

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Upgrade to Oracle9i then at least it won't lock out DML

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

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