Re: 11gR1 issues

  • From: Kumar Madduri <ksmadduri@xxxxxxxxx>
  • To: Anurag Verma <anuragdba@xxxxxxxxx>
  • Date: Thu, 4 Mar 2010 16:23:48 -0800

Thank you Anurag.
In our case, it is disabled.


On Thu, Mar 4, 2010 at 12:18 PM, Anurag Verma <anuragdba@xxxxxxxxx> wrote:

> There is this Automatic SQL tuning in 11g...
> It will apply SQL profiles when it finds that a SQL is performing bad...
> You can disable this automatic behavior and check whether you get any
> improvements....
> Anurag
> On Wed, Mar 3, 2010 at 8:07 AM, Kumar Madduri <ksmadduri@xxxxxxxxx> wrote:
>> Hello:
>> We are having quiet  a few issues after 11g upgrade from
>> ( to in an Oracle Apps environment.
>> Some of the issues are (a) rman restore was slow (b)  Frequent checkpoints
>> and dbwr was waiting for ckpt to complete  (c) Lot of 7445 errors
>>  For these type of issues we have patches from Oracle or under
>> investigation from Oracle
>> We also have lot of bad application sql and it turned worse in 11g and
>> developers say they did not make any change which is true. There is
>> definately a change in execution plans on a  lot of these ugly queries as
>> can be seen from 10053 and 10046 traces. Tuning these queries can take a
>> long time and developers and managers just want a quick fix and the quick
>> fix is to set the optimizer_features_enabled to which fixes the
>> issue in most cases.
>> But that is not the right thing to do.
>> From DBA point of view, all was done was an upgrade and our stats
>> collection does not change.No new features were implemented. No storage was
>> changed. We use SAN and ASM
>> Questions I have are
>> 1. Have an you upgraded to and experienced these issues in an
>> Oracle Apps environment?
>> 2. I read that 11gR2 is more stable and less buggy.  Can anyone confirm
>> that to be true (in relation to 11gR1).
>> Thank you
>> Kumar
> --
> Anurag Verma,
> Database Administrator
> ERCOT(Electric Reliability Council of Texas),
> Texas 76574

Other related posts: