Re: Database perfortmance degraded drastically after upgrading the database from Oracle 102.0.4 to Oracle 11.2.0.3

I's strongly encourage using a tuning methodology, such as can be found in many books. I like Christian's "Troubleshooting Oracle Performance", but there are many others that are excellent as well. If you can't afford books, start reading the '2-day tuning' crash course and 'tuning guide' at http://docs.oracle.com/cd/E11882_01/nav/portal_17.htm

Without a methodology, especially in finding out where the problem comes from, all you are doing is spraying possible ideas to see which will stick, and risk making things worse.

Basically - find out which resource(s) are your problem.

/Hans

On 19/10/2015 1:48 PM, Mandal, Ashoke wrote:
>
> It is on Solrais 10.
>
> *From:*oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] *On Behalf Of *Hans Forbrich
> *Sent:* Monday, October 19, 2015 2:41 PM
> *To:* oracle-l_at_freelists.org
> *Subject:* Re: Database perfortmance degraded drastically after
> upgrading the database from Oracle 102.0.4 to Oracle 11.2.0.3
>
> Which platform, which features and options do you have?
>
> I would recommend using Diag Pack and AWR reports, but if you don't
> have EE and OEM and DiagPack, it would be a wast of time recommending
> them.
>
> /Hans
>
> On 19/10/2015 1:21 PM, Mandal, Ashoke wrote:
>
> Greetings All,
>
> After the upgrade of one of my databases from Oracle 10.2.0.4 to
> Oracle 11.2.0.3 the users are experiencing poor query performance.
> The response time of the queries have increased by 15 times.
>
> I have tried the following without any luck but checking if you
> have any other suggestions
>
> 1.Changed optimizer_dynamic_sampling from 2 to 1 => No performance
> improvement
>
> 2.Changed optimizer_features_enable to '10.2.0.4' => No
> performance improvement
>
> 3.Try setting cursor_sharing to force => No performance improvement
>
> 4.Set “_optimizer_skip_scan_enabled" = FALSE => No performance
> improvement
>
> Please let me know if you any suggestions to resolve this issue
>
> Appreciate your help in advance,
> Ashoke
>
>
>
> [CONFIDENTIALITY AND PRIVACY NOTICE] Information transmitted by
> this email is proprietary to Medtronic and is intended for use
> only by the individual or entity to which it is addressed, and may
> contain information that is private, privileged, confidential or
> exempt from disclosure under applicable law. If you are not the
> intended recipient or it appears that this mail has been forwarded
> to you without proper authority, you are notified that any use or
> dissemination of this information in any manner is strictly
> prohibited. In such cases, please delete this mail from your
> records. To view this notice in other languages you can either
> select the following link or manually copy and paste the link into
> the address bar of a web browser:
> http://emaildisclaimer.medtronic.com
>

--
http://www.freelists.org/webpage/oracle-l