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

Thread: Init.ora question

  1. 09-28-2006, 04:43 PM #1
    vision
    vision is offline Junior Member
    Join Date
    May 2006
    Posts
    51

    Init.ora question

    In oracle 9i what is the best setting in init.ora file for _b_tree_bitmap_plan parameter. Due we need to set to true or false because some of report are failing on this parameter
    Reply With Quote Reply With Quote
  2. 09-28-2006, 05:13 PM #2
    slimdave
    slimdave is offline Foreign Script Kiddie
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Since it's a hidden parameter, you should get the agreement of Oracle supoport in changing it.

    However for an OLTP database "false" would generally be the accepted norm. I believe the default might have changed from "false" in 8i to "true" in 9i.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE
    Reply With Quote Reply With Quote
  3. 09-29-2006, 02:18 AM #3
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    why would one need to get a agreement from oracle support for such things.. if we have a licence of the product.. dont we have rights to do anything and every thing?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
    Reply With Quote Reply With Quote
  4. 09-29-2006, 04:07 AM #4
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    they are undocumented for a reason, i.e. generally you dont know what effect they have on the datagase, therefore shouldnt set them.

    Not you cant, but shouldnt
    Reply With Quote Reply With Quote
  5. 09-29-2006, 07:43 AM #5
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    it would be at our own risk to face the consequences by changing undocumented things.. i know that.. thats fine & obivious.. but i thought if there will be legal issues?..

    not sure what dave meant by agreement with support services..

    * i was keen to know on leagal issues rather then techinical issues

    - Abhay
    Last edited by abhaysk; 09-29-2006 at 07:46 AM.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
    Reply With Quote Reply With Quote
  6. 09-29-2006, 12:15 PM #6
    KenEwald's Avatar
    KenEwald
    KenEwald is offline Senior Advisor
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Quote Originally Posted by vision
    In oracle 9i what is the best setting in init.ora file for _b_tree_bitmap_plan parameter. Due we need to set to true or false because some of report are failing on this parameter
    Correct me if I'm wrong here, but did you say it's a TRUE/FALSE parameter and you want to know the best setting?

    The one that works, there's only 3 options here... TRUE, FALSE, and Not set (which is likely TRUE or FALSE, so in all likelihood, you really have only 2 choices)

    Test them...

    Cheers!

    Ken
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need
    Reply With Quote Reply With Quote
  7. 10-01-2006, 11:38 AM #7
    tamilselvan
    tamilselvan is offline Senior Advisor
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Quote Originally Posted by abhaysk
    it would be at our own risk to face the consequences by changing undocumented things.. i know that.. thats fine & obivious.. but i thought if there will be legal issues?..

    not sure what dave meant by agreement with support services..

    * i was keen to know on leagal issues rather then techinical issues

    - Abhay
    Legal issues:
    By setting this parameter w/o support of Oracle Corp, you may expect some data loss that may lead to business loss. Then, you file a case against Oracle corp. To avoid such a complicated court case, it would be better to get the support of Oracle corp before you change the parameter.

    Tamil
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width