Replies to This Discussion

Permalink Reply by Michale Johannsen on May 7, 2013 at 4:18am

Shelli,

Have you had any luck with this yet? We are also in the midst of upgrading to 11g (from 10g) and are also seeing performance issues. Anecdotaly, "views take forever to build, SQR's are slow", etc. Also, I am seeing a hit when doing explain plans (2 seconds to 15-20 seconds).

We adjusted the parameters as per Doc. ID 749100.1, but its only allowed us some small benefits. We are looking into setting optimizer_features_enable to 10.2.0, but that seems like a "why bother doing the 11g upgrade in the first place" sort of thing.
I've created an SR as well, but no joy yet.

• ▶ Reply

Permalink Reply by Ressie Borman on May 7, 2013 at 4:27am

I recognize that document. 
we've upgraded the Financials (App 9.0 tools 8.48.09) side over a week ago, and things are running somewhat okay there, only the nVisions still have some longer run times, by a few hours (month-end report generation).

On the HR (App 8.9 tools 8.49.12) we are seeing somewhat similar run times comparing the 11.1.0.7 instance to the 10.2.0.3 instance, but one app engine, TL_TIMEADMIN, is running twice as long, hours longer. That's a huge concern for the clients. Anyway, we had those silver bullet parms in our 10g instances and carried them along into 11g, per the documentation. I did find another doc on Oracle Metalink, by way of another document on PS Metalink, 
Oracle 11gR1 Upgrade Companion 
Doc ID: 601807.1 
which does have some good stuff in it. Also, we're playing with the db_file_multiblock_read_count parameter (don't set it, allow Oracle to manage) but not seeing much with that. And we are looking at optimizer settings but it's a bit hard as the HR folk are also putting in ePay, eProfile, and Recruiting Solutions in the next few months. They're busy.
So, optimizer settings-
OPTIMIZER_DYNAMIC_SAMPLING = 0
(bind peeking)
and who knows what else the developers want to try

• ▶ Reply

Permalink Reply by pavan kumar on August 16, 2013 at 8:42am

Hi Shelli,

This is Pavan from PeopleTech Group. . I’d request for an opportunity to speak with you, discuss our experience, on this. I was wondering if we can have a quick call this coming week some time? Waiting for your quick response.

-Pavan.

• ▶ Reply

Permalink Reply by kristen on July 9, 2017 at 12:44pm

it's a pleasure to meet you. I am USA Army personnel, i have an important thing to discus with you.
Please write me on my email (captkristen899@gmail.com)

• ▶ Reply