MISSING DATA AFTER A PEOPLESOFT UPGRADE

Posted by: Don VanWieren oracle1 I recently resolved an issue for one of our clients. The client had upgraded their PeopleSoft system to the latest version and indicated some data was missing and wondered why the upgrade had not created the data. After researching it a bit and with experience with other clients, I discovered the problem was not with the upgrade. Apparently, after the upgrade, a bundle was applied and a script from a bundle was either not run or was run at an improper time and, as a result, the data was not created. After reviewing the issue, we determined that the script could still be run. Data then was migrated and the client’s issue was resolved.

Read More →

SOLVING PEOPLESOFT PERFORMANCE ISSUES WITH ORACLE RAC TUNING

oracle1While recently working with one of my clients, a large college which has an Oracle RAC 11g on Linux setup, I noticed that certain PeopleSoft batch processes were slow compared to what I have observed at other client sites. I confirmed with the user that the slow performance, in fact, was impacting the end user. I began to research the issue by taking some database snapshots and I reviewed other statistics that confirmed that there were a large number of enqueue waits for TAO tables. While an enqueue is not RAC specific, it can involves a global lock operation when RAC is enabled. Most of the global requests for enqueues are synchronous, and foreground processes wait for them. Therefore contention on enqueues in RAC is more visible than in single instance environments. I ran a PeopleSoft trace to identify the objects or tables involved and found that most of the waits were on truncate table commands for the TAO tables. PeopleSoft operations use a lot of TAO, temporary tables, which are not truly temporary by Oracle’s definition, however these are actual tables where intermediate operations ...

Read More →