-
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!
-
Hi,
I would set it to all_rows.
How much memory do you plan to allocate to your SGA and PGA ?
-
I would set it to "read_and_understand_concepts_guide_before_I_change_anything", but that's just me.
Jeff Hunter
-
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"
-
sometimes I wonder how people cant learn in 5 years time
-
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"
-
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.
-
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.
-
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"
-
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 10: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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|