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!
Printable View
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.
PS All_Rows is FTS prone.. :) :) ( Better take Marist's suggestion )
sometimes I wonder how people cant learn in 5 years time
Still 2 more months to go ;) ;) ( for completing 5 full yrs lol )Quote:
Originally posted by pando
sometimes I wonder how people cant learn in 5 years time
PPS Better to say that First_Rows is index-prone. FTS is not neccessarily a bad thing in a database, especially a data warehouse.Quote:
Originally posted by abhaysk
PS All_Rows is FTS prone.. :) :) ( Better take Marist's suggestion )
... and there's a whole book on data warehousing that should be read, as well as the performance and tuning guide.Quote:
Originally posted by marist89
I would set it to "read_and_understand_concepts_guide_before_I_change_anything", but that's just me.
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..Quote:
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.
Abhay.
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