how to analyze LOB index
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: how to analyze LOB index

  1. #1
    Join Date
    Jan 2003
    Posts
    141

    how to analyze LOB index

    hi,
    got an error when analyzing a lob index using dbms_stats.gather_index_stats.This analyze is shceduled as a job in OEM.

    ORA-20000: Unable to analyze INDEX "TABLENAME"."SYS_IL0000009959C00003$$",
    insufficient privileges or does not exist
    ORA-06512: at "SYS.DBMS_STATS", line 8195
    ORA-06512: at "SYS.DBMS_STATS", line 8234


    Many Thanks,

  2. #2
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    I'm guessing that's not an option. Notice what the 9i docs say about analyzing a table with a LOB column .. it's skipped.

    "You cannot compute or estimate statistics for the following column types: REFs, varrays, nested tables, LOBs (LOBs are not analyzed, they are skipped), LONGs, or object types. However, if a statistics type is associated with such a column, then user-defined statistics are collected."
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  3. #3
    Join Date
    Jan 2003
    Posts
    141
    I have a BLOB column in the table AAA which created the LOB index

    INDEX_NAME INDEX_TYPE TABLE_NAME
    ------------------------------ ---------------------------
    SYS_IL0000009959C00003$$ LOB AAA


    Just a clarification, the BLOB column which has created a LOB index cannot be analyzed.

    (ie)

    begin
    dbms_stats.gather_index_stats(ownname=> 'AAA', indname=> 'SYS_IL0000009959C00003$$', partname=> NULL);
    end;


    Many Thanks,

  4. #4
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    I think the only thing you can do is specify at table (lob column) creation where the lob index will live. If you don't have a ton of lob's, I wouldn't even concern myself with it.

    Best of luck.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

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