RE: 10g RAC using raw devices - curiousity question

From: <Christopher.Taylor2_at_parallon.net>
Date: Mon, 24 Sep 2012 21:05:27 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E88515BD74EA_at_NADCWPMSGCMS10.hca.corpad.net>

What is the concern, and what about it concerns you if I were to move it to production?

Chris

-----Original Message-----
From: Martin Klier [mailto:usn_at_usn-it.de] Sent: Monday, September 24, 2012 5:07 PM To: Taylor Christopher - Nashville
Cc: oracle-l_at_freelists.org
Subject: Re: 10g RAC using raw devices - curiousity question

Uahhh
=:-O

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

Received on Mon Sep 24 2012 - 21:05:27 CDT