Re: very impressed by 11g

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 25 Apr 2012 15:57:44 +0000 (UTC)
Message-ID: <jn96tn$j2v$1_at_solani.org>

On Wed, 25 Apr 2012 01:33:50 -0700, Gerard H. Pille wrote:

> It was all the little processes together. We keep session statistics so
> we will be able to compare now the users are back to their workstations.
>
> compatible = "11.2.0.0"
> was
> compatible = "10.1.0"
>
> servr1.DBRMG>select version from v$instance;
> VERSION -----------------
> 11.2.0.2.0
>
> It looks like we don't capture the plan baselines automatically:
> servr1.DBRMG>show parameter optim ...
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> object_cache_optimal_size integer 102400
> optimizer_capture_sql_plan_baselines boolean FALSE
> optimizer_dynamic_sampling integer 0
> optimizer_features_enable string 11.2.0.2
> optimizer_index_caching integer 50
> optimizer_index_cost_adj integer 10 optimizer_mode
> string CHOOSE optimizer_secure_view_merging
> boolean TRUE optimizer_use_invisible_indexes boolean FALSE
> optimizer_use_pending_statistics boolean FALSE
> optimizer_use_sql_plan_baselines boolean TRUE
> plsql_optimize_level integer 2

Gerard, 11.2.0.2 has a bug in the mutex code. The bug number is 12431716. The same thing happened to me a year ago, I even wrote about it on this very forum. I know the bug number because I opened a SR and that's what they gave me. The issues were gone once the April 2011 PSU for 11.2.0.2 was installed. Personally, my advice would be to upgrade to 11.2.0.3 and install the April 2012 PSU.

-- 
http://mgogala.byethost5.com

Received on Wed Apr 25 2012 - 10:57:44 CDT