Anyone have any experience upgrading to Oracle 11g? We are seeing some definite performance hits on PeopleSoft Financials with respect to nVision and sqrs. I've searched on metalink for performance documentation but so far, no luck. I do have an SR with PS/Oracle, but thought I'd try you folks to see if anyone has any documentation or links. We are currently testing one upgraded instance from 10.2.0.3 to 11.1.0.7 in both PS FS and HR.

Views: 286

Reply to This

Replies to This Discussion

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.

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

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.

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)

RSS

PeopleSoft Jobs in US

Videos

  • Add Videos
  • View All

© 2021   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service