Bitmap Conversion To Rowids - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 19 of 19

Thread: Bitmap Conversion To Rowids

  1. #11
    Join Date
    Nov 2000
    Posts
    440
    Here is how i collected statistics on my materialized view:
    execute dbms_stats.gather_table_stats(ownname=> 'MUS_GEN3', tabname=> 'MV_SONG' , estimate_percent=>
    DBMS_STATS.AUTO_SAMPLE_SIZE, cascade=> DBMS_STATS.AUTO_CASCADE, degree=> null, no_invalidate=> DBMS_STATS.AUTO_INVALIDATE,
    granularity=> 'AUTO',method_opt=> 'FOR ALL COLUMNS SIZE AUTO');

    Will cascade=> DBMS_STATS.AUTO_CASCADE collect stats on indexes related to my mv?

    Should i have collected stats on my mv a different way?

    The index used in the plan is correct btw, the same as in my dev database.
    It is the bitmap conversion that is not right. So by increasing the “blevel” or leaf blocks values in one of the indexes will make the plan use another index? Or simply stop bitmap conversion on me?

    And again, there is no bitmap index in my database. I have a oltp system.

  2. #12
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    its nothing to do with bitmap indexes, so dont get confused. If it causing you a problem set that parameter pando mentioned

  3. #13
    Join Date
    Nov 2000
    Posts
    440
    _b_tree_bitmap_plans is already set to false. It is still happening.

  4. #14
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Have you checked the bugs I posted earlier?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #15
    Join Date
    Nov 2000
    Posts
    440
    Im on 10.2.0.3. The metalink note is for 9i. The doc says to change the parameter wish i did.

  6. #16
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    dont wish it - do it!

  7. #17
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    When talking about bugs, you don't trust literally what a Oracle Note says about affected versions.

    You are in 10g and bug affected 9i?... check the date of the note, chances are Ora10g wasn't an active product when it was written. Bug might be there, alive and kicking
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  8. #18
    Join Date
    Nov 2000
    Posts
    440
    I have change the parameter, still happening.

  9. #19
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    so why not try using index/es hint?
    ---------------

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