database parameters for a data warehouse environment
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: database parameters for a data warehouse environment

  1. #1
    Join Date
    Jun 2000
    Posts
    315

    database parameters for a data warehouse environment

    What are the typical parameters should be set for a data warehouse database?

    Should optimizer_mode be set to choose or all_rows or anything else?

    Thanks!

  2. #2
    Join Date
    Mar 2002
    Posts
    534
    Hi,

    I would set it to all_rows.

    How much memory do you plan to allocate to your SGA and PGA ?

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I would set it to "read_and_understand_concepts_guide_before_I_change_anything", but that's just me.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    PS All_Rows is FTS prone.. ( Better take Marist's suggestion )
    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"

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    sometimes I wonder how people cant learn in 5 years time

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by pando
    sometimes I wonder how people cant learn in 5 years time
    Still 2 more months to go ( for completing 5 full yrs lol )
    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"

  7. #7
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by abhaysk
    PS All_Rows is FTS prone.. ( Better take Marist's suggestion )
    PPS Better to say that First_Rows is index-prone. FTS is not neccessarily a bad thing in a database, especially a data warehouse.
    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE

  8. #8
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by marist89
    I would set it to "read_and_understand_concepts_guide_before_I_change_anything", but that's just me.
    ... and there's a whole book on data warehousing that should be read, as well as the performance and tuning guide.
    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE

  9. #9
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by slimdave
    PPS Better to say that First_Rows is index-prone. FTS is not neccessarily a bad thing in a database, especially a data warehouse.
    Well i just cautioned... most often then not a FTS is good DW environments... but still depends.. and taking a look at how application queries ( extensively used ) the DB would be better..

    Abhay.
    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"

  10. #10
    Join Date
    Mar 2002
    Posts
    534
    Who of you ever work on a larger DWH project? Because in a DWH envrionment I realy don't see why the optimizer mode "all_rows" should be a problem.

    And the "RTFM" guys may have a look at:
    http://download-west.oracle.com/docs...resh.htm#12420
    http://download-west.oracle.com/docs....htm#sthref798
    Last edited by mike9; 04-06-2005 at 11:28 AM.

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