Re: very impressed by 11g

From: Gerard H. Pille <ghpille_at_hotmail.com>
Date: Wed, 23 May 2012 00:35:02 -0700 (PDT)
Message-ID: <a23e59c4-f395-4000-84e4-4bbefdf9659f_at_googlegroups.com>



Op woensdag 25 april 2012 17:57:44 UTC+2 schreef Mladen Gogala het volgende:
> 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

Mladen, you wouldn't happen to know a test-scenario that allows one to check if this problem has been solved?

Thanks,

Gerard Received on Wed May 23 2012 - 02:35:02 CDT

Original text of this message