David Kurtz /*+Go-Faster*/ Consultancy
@go-faster.co.uk
Oracle Database Performance Specialist. People Performance Specialist. Independent Consultant. Oracle ACE Director. OakTable. Sym42. Cyclist. Cat herder.
https://www.go-faster.co.uk
https://www.go-faster.co.uk
The /*+Go-Faster*/ Oracle Blog: Partition Pruning/Elimination on Reference Partitioned Tables: blog.go-faster.co.uk/2025/09/refp...
Partition Pruning/Elimination on Reference Partitioned Tables
I discussed locally partitioning the unique index on reference partitioned table in a previous blog . Having implemented it, I wanted to co...
blog.go-faster.co.uk
September 2, 2025 at 1:49 PM
The /*+Go-Faster*/ Oracle Blog: Partition Pruning/Elimination on Reference Partitioned Tables: blog.go-faster.co.uk/2025/09/refp...
The /*+Go-Faster*/ Oracle Blog: Deadlock within DML statements blog.go-faster.co.uk/2025/07/dead...
Deadlock within DML statements
Oracle have provided a very detailed note Troubleshooting "ORA-00060 Deadlock Detected" Errors (Doc ID 62365.1) . This document includes a...
blog.go-faster.co.uk
July 1, 2025 at 2:39 PM
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...
Optimising Journal Line Queries: 5. Conclusion
A blog about PeopleSoft, Oracle database, and performance tuning
blog.psftdba.com
June 30, 2025 at 1:09 PM
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...
Optimising Journal Line Queries: 4. Compression
A blog about PeopleSoft, Oracle database, and performance tuning
blog.psftdba.com
June 27, 2025 at 2:41 PM
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...
Optimising Journal Line Queries: 3. Partitioning
A blog about PeopleSoft, Oracle database, and performance tuning
blog.psftdba.com
June 26, 2025 at 1:00 PM
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...
Optimising Journal Line Queries: 2. Exadata System Statistics
A blog about PeopleSoft, Oracle database, and performance tuning
blog.psftdba.com
June 24, 2025 at 3:22 PM
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...
Optimising Journal Line Queries: 1. Problem Statement
A blog about PeopleSoft, Oracle database, and performance tuning
blog.psftdba.com
June 23, 2025 at 8:22 PM
The PeopleSoft DBA Blog: Optimising Journal Line Queries: 1. Problem Statement blog.psftdba.com/2024/12/jour...
The PeopleSoft DBA Blog: Logging Run Controls and Bind Variables for Scheduled PS/Queries - blog.psftdba.com/2025/04/logg...
Logging Run Controls and Bind Variables for Scheduled PS/Queries
A blog about PeopleSoft, Oracle database, and performance tuning
blog.psftdba.com
May 8, 2025 at 8:09 AM
The PeopleSoft DBA Blog: Logging Run Controls and Bind Variables for Scheduled PS/Queries - blog.psftdba.com/2025/04/logg...
The /*+Go-Faster*/ Oracle Blog: Configuring SQL Developer to Authenticate Via Kerberos - blog.go-faster.co.uk/2025/05/kerb...
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...
blog.go-faster.co.uk
May 5, 2025 at 10:19 PM
The /*+Go-Faster*/ Oracle Blog: Configuring SQL Developer to Authenticate Via Kerberos - blog.go-faster.co.uk/2025/05/kerb...
The /*+Go-Faster*/ Oracle Blog: Locally Partitioned Unique Indexes on Reference Partitioned Tables - blog.go-faster.co.uk/2025/03/refe...
Locally Partitioned Unique Indexes on Reference Partitioned Tables
Normally, if you want to locally partition a unique index, you must include the partitioning key in the index key. Otherwise, you get will ...
blog.go-faster.co.uk
March 18, 2025 at 3:44 PM
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...
A Resource Manager CPU Time Limit for PS/Queries Executed On-line in the PIA
A blog about PeopleSoft, Oracle database, and performance tuning
blog.psftdba.com
March 6, 2025 at 7:40 AM
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...
SQL Quarantine Behaviour When the Same SQL Executes in Different Resource Manager Consumer Groups With Different CPU Time Limits
What happens if I have two consumer groups with different CPU time limits, but the same long-running SQLs can be run in either group? There ...
blog.go-faster.co.uk
March 4, 2025 at 5:27 PM
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...
New Parameters In 21c To Control Automatic SQL Quarantine Can Be Backported To 19c
SQL Quarantine is only available on Exadata. In 19c, automatic quarantine generation and subsequent use are enabled by default. In Oracle...
blog.go-faster.co.uk
March 3, 2025 at 8:34 PM
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...
Quarantined SQL Plans for PS/Queries
A blog about PeopleSoft, Oracle database, and performance tuning
blog.psftdba.com
February 24, 2025 at 5:49 PM
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)! 🤦♂️
February 24, 2025 at 4:00 PM
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...
Management of Long Running PS/Queries Cancelled by Resource Manager CPU Limit
A blog about PeopleSoft, Oracle database, and performance tuning
blog.psftdba.com
February 20, 2025 at 11:49 AM
The PeopleSoft DBA Blog: Management of Long Running PS/Queries Cancelled by Resource Manager CPU Limit - blog.psftdba.com/2025/02/mana...
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-...
SQL Profiles for Application Engine Steps that Reference Temporary Records via the %Table() Meta-SQL
A blog about PeopleSoft, Oracle database, and performance tuning
blog.psftdba.com
January 28, 2025 at 5:46 PM
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-...
Reposted by David Kurtz /*+Go-Faster*/ Consultancy
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…
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…
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.
mikedietrichde.com
December 3, 2024 at 10:01 AM
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…
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…
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
- 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
In the Cloud Performance is Instrumented as Cost - A Resource Plan for PeopleSoft
A blog about PeopleSoft, Oracle database, and performance tuning
blog.psftdba.com
December 2, 2024 at 10:47 PM
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
- 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
December 2, 2024 at 2:54 PM
In the absence of a screen @ora600pl.bsky.social draws an database activity chart with beer cans! #UKOUG #UKOUGDiscover24 #UKOUG
December 2, 2024 at 12:19 PM
In the absence of a screen @ora600pl.bsky.social draws an database activity chart with beer cans! #UKOUG #UKOUGDiscover24 #UKOUG
A final look through "In the Cloud, Performance is instrumented as Cost - A Resource Plan for PeopleSoft" for tomorrow at #UKOUG #UKOUGDiscover24 #UKOUG. A database session with a real-life PeopleSoft example, but in the Applications agenda - virtual.oxfordabstracts.com/event/73719/...
OA Virtual conferences
virtual.oxfordabstracts.com
December 1, 2024 at 11:17 PM
A final look through "In the Cloud, Performance is instrumented as Cost - A Resource Plan for PeopleSoft" for tomorrow at #UKOUG #UKOUGDiscover24 #UKOUG. A database session with a real-life PeopleSoft example, but in the Applications agenda - virtual.oxfordabstracts.com/event/73719/...
My presentation "Read Consistency: Why You Need It and How to Avoid It" from #UKOUG24 #UKOUGDiscover24 #UKOUG - is now on slideshare - www.slideshare.net/slideshow/re...
Read Consistency: Why You Need it and How to Avoid it
Read Consistency: Why You Need it and How to Avoid it - Download as a PDF or view online for free
www.slideshare.net
December 1, 2024 at 10:45 PM
My presentation "Read Consistency: Why You Need It and How to Avoid It" from #UKOUG24 #UKOUGDiscover24 #UKOUG - is now on slideshare - www.slideshare.net/slideshow/re...