Re: 10g RAC using raw devices - curiousity question

For a sandbox, it's a brave approach. Hope this isn't production.

Christopher.Taylor2_at_parallon.net schrieb:
>
> alter session set workarea_size_policy=manual;
> alter session set sort_area_size=1073741824;
> alter session set hash_area_size=1073741824;
> alter session set "_complex_view_merging"=FALSE; --- found on Metalink
> for a different perf problem & still testing
> alter session set "_sort_multiblock_read_count"=256; --- set for
> workarea_size_policy manual
> alter session set "_hash_multiblock_io_count"=256; --- set for
> workarea_size_policy manual
> alter session set "_unnest_subquery"=FALSE; --- found on Metalink for a
> different perf problem & still testing
> alter session set "_optimizer_use_histograms"=false; --- Current
> statistics gathering strategy needs work
> alter session set "_optimizer_squ_bottomup"=false; --- Metalink Note:
> 1118446.1
> alter session set "_optimizer_sortmerge_join_enabled"=false; ---Metalink
> Note: 444609.1
> alter session set "_optimizer_join_sel_sanity_check" = true; ---
> alter session set "_always_semi_join" = off;
> alter session set "_optimizer_max_permutations"=80000; ---
> alter session set "_OPTIMIZER_COST_BASED_TRANSFORMATION"=EXHAUSTIVE;
> ---Metalink Note: 567354.1 -- testing
> alter session set "_newsort_enabled"=false; --Metalink Bug 6817844.8 --
> testing, zero effect observed

-- 
Usn's IT Blog for Linux, Oracle, Asterisk
http://www.usn-it.de

--
http://www.freelists.org/webpage/oracle-l