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.
ACCEPT_SQL_PROFILES FALSE
Kumar
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 10.2.0.4
>> (10.2.0.4 to 11.1.0.7.1) 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 10.2.0.4 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 11.1.0.7.1 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:
