DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: VALIDATE STRUCTURE Online

  1. #1
    Join Date
    Jul 2001
    Posts
    108

    Question VALIDATE STRUCTURE Online

    Hello,

    When I ran the following index validate command it is not populating the table INDEX_STATS.

    ANALYZE INDEX "ADR2~I01" VALIDATE STRUCTURE Online;

    What is the reason behind it and how can I will get to know the values for height, blocks, lf_rows, lf_blks and del_lf_rows ???

    Thanks,
    Nikee

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Use it without the ONLINE option:

    ANALYZE INDEX "ADR2~I01" VALIDATE STRUCTURE;

    As per oracle documentation, when you perform "ANALYZE... VALIDATE STRUCTURE ONLINE", no statistics are gathered, the process only validates the integrity of the object:
    When you validate the structure of an object ONLINE, Oracle does not collect any statistics, as it does when you validate the structure of the object OFFLINE
    .

    Regarding the question about where to get various index statistics from: You can get all of them (except del_lf_rows) in DBA_/ALL_USER_INDEXES. You must of course first collect those statistics either with ANALYZE command or (preferebly) by using DBMS_STATS.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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