David Kurtz /*+Go-Faster*/ Consultancy

Determining Optimal Index Key Compression Length A blog about PeopleSoft, Oracle database, and performance tuning

blog.psftdba.com/2025/07/opti...

The /*+Go-Faster*/ Oracle Blog: Deadlock within DML statements blog.go-faster.co.uk/2025/07/dead...

The PeopleSoft DBA Blog: Optimising Journal Line Queries: 5. Conclusion blog.psftdba.com/2025/05/opti...

The PeopleSoft DBA Blog: Optimising Journal Line Queries: 4. Compression blog.psftdba.com/2024/12/opti...

The PeopleSoft DBA Blog: Optimising Journal Line Queries: 3. Partitioning blog.psftdba.com/2024/12/opti...

The PeopleSoft DBA Blog: Optimising Journal Line Queries: 2. Exadata System Statistics ... blog.psftdba.com/2024/12/jour...

The PeopleSoft DBA Blog: Optimising Journal Line Queries: 1. Problem Statement blog.psftdba.com/2024/12/jour...

Logging Run Controls and Bind Variables for Scheduled PS/Queries A blog about PeopleSoft, Oracle database, and performance tuning

The PeopleSoft DBA Blog: Logging Run Controls and Bind Variables for Scheduled PS/Queries - blog.psftdba.com/2025/04/logg...

Configuring SQL Developer to Authenticate Via Kerberos Kerberos is a trusted third-party authentication system that relies on shared secrets and presumes that the third party is secure (see  Orac...

The /*+Go-Faster*/ Oracle Blog: Configuring SQL Developer to Authenticate Via Kerberos - blog.go-faster.co.uk/2025/05/kerb...

Network latency can make chattiness a problem. More generally I think that not using PL/SQL leads to chattiness and literals. Then parse can become a problem and an expense.

In PeopleSoft that would be close to 100%! I can't think of a practical use of such a ratio. Chatty apps usually aren't instrumented so can't identify chattiest parts.

Perhaps parse is the critical metric?

I was always impressed how well PeopleSoft could perform, given how badly it behaves. No PL/SQL, just a stream of SQL. Often dynamically generated with literals. HR with Time&Labor and Payroll on a pay week was always fun.

The /*+Go-Faster*/ Oracle Blog: Locally Partitioned Unique Indexes on Reference Partitioned Tables - blog.go-faster.co.uk/2025/03/refe...

The PeopleSoft DBA Blog: A Resource Manager CPU Time Limit for PS/Queries Executed On-line in the PIA - blog.psftdba.com/2025/03/reso...

The /*+Go-Faster*/ Oracle Blog: SQL Quarantine Behaviour When the Same SQL Executes in Different Resource Manager Consumer Groups With Different CPU Time Limits ... blog.go-faster.co.uk/2025/03/SQLq...

The /*+Go-Faster*/ Oracle Blog: New Parameters In 21c To Control Automatic SQL Quarantine Can Be Backported To 19c ... blog.go-faster.co.uk/2025/03/sqlq...

The PeopleSoft DBA Blog: Quarantined SQL Plans for PS/Queries blog.psftdba.com/2025/02/quar...

Today's gotcha: NB: PLAN_HASH_VALUE on DBA_SQL_QUARANTINE is the adaptive plan hash value (with all of its possible plan alternatives), and therefore it matches SQL_FULL_PLAN_HASH_VALUE in the ASH data, and not SQL_PLAN_HASH_VALUE (the plan that actually executed)! 🤦‍♂️

The PeopleSoft DBA Blog: Management of Long Running PS/Queries Cancelled by Resource Manager CPU Limit - blog.psftdba.com/2025/02/mana...

I have a memory that the RAC and AA keys would both open boxes for both organisations.

The PeopleSoft DBA Blog: SQL Profiles for Application Engine Steps that Reference Temporary Records via the %Table() Meta-SQL: blog.psftdba.com/2025/01/sql-...

We had a Commodore PET at school in about 1981. Those were the days.

The Sky is Blue from now on! You may or may not have seen it but a good part of the tech community, especially dealing with Oracle technology or tech generally, has moved on now. And actually I did just the same. So, The Sky is Blue from now on! What does it mean? I use so-called social media for two reasons mostly. At first, I would like to stay in touch with friends, colleagues and customers.

The Sky is Blue from now on!

You may or may not have seen it but a good part of the tech community, especially dealing with Oracle technology or tech generally, has moved on now. And actually I did just the same. So, The Sky is Blue from now on! What does it mean? I use so-called social media for…

@oraclebase.bsky.social and Klaus

It was the least worst!

In the Cloud, Performance is Instrumented as Cost
- A Resource Plan for PeopleSoft ... blog.psftdba.com/2024/12/in-c...
A presentation about both the Oracle database & PeopleSoft ERP from #UKOUG #UKOUGDiscover24 #UKOUG, now on the PeopleSoft DBA Blog

Coming soon #UKOUG #UKOUGDiscover24 #UKOUG

In the absence of a screen @ora600pl.bsky.social draws an database activity chart with beer cans! #UKOUG #UKOUGDiscover24 #UKOUG