The PeopleSoft DBA Blog

This blog contains things about PeopleSoft, mostly performance related, that DBAs might find interesting.
Or then again they might not! The non-PeopleSoft Oracle stuff is at blog.go-faster.co.uk.

Announcements

▼

Thursday, March 06, 2025

A Resource Manager CPU Time Limit for PS/Queries Executed On-line in the PIA

›

In previous posts, I have proposed: A Sample Oracle Database Resource Manager Plan for PeopleSoft . It can be downloaded from Github: PSF...

Monday, February 24, 2025

Quarantined SQL Plans for PS/Queries

›

This follows on from my previous post, Management of Long Running PS/Queries Cancelled by Resource Manager . From 19c, on Engineered System...

Thursday, February 20, 2025

Management of Long Running PS/Queries Cancelled by Resource Manager CPU Limit

›

I have written previously about using the Oracle database resource manager to prioritise the allocation of CPU to different processes in a P...

Tuesday, January 28, 2025

SQL Profiles for Application Engine Steps that Reference Temporary Records via the %Table() Meta-SQL

›

Oracle generally advises using SQL Profiles/Patches/Baselines rather than introducing hints into application code. Using one of these forms...

Monday, December 02, 2024

In the Cloud Performance is Instrumented as Cost - A Resource Plan for PeopleSoft

›

In the cloud, either you are spending too much money on too much CPU, or your system is constrained by CPU at peak times. You can have as m...

›

Home

View web version