David Kurtz - /*+Go-Faster*/ Consultancy 🇺🇦
@davidmkurtz
Followers
721
Following
3K
Media
57
Statuses
561
Oracle Database Performance Specialist. PeopleSoft Performance Specialist. Independent Consultant. OakTable. Oracle ACE Director. Sym42.
N 51°31' 0'' / W 0°8' 0''
Joined November 2009
/*+Go-Faster*/ Consultancy is back! I am going back to independent Oracle database performance consultancy. And PeopleSoft performance consultancy too!
0
3
11
The PeopleSoft DBA Blog: Determining Optimal Index Key Compression Length
0
0
1
The /*+Go-Faster*/ Oracle Blog: Deadlock within DML statements
0
0
1
The PeopleSoft DBA Blog: Optimising Journal Line Queries: 5. Conclusion
0
0
0
The PeopleSoft DBA Blog: Optimising Journal Line Queries: 4. Compression
0
0
1
The PeopleSoft DBA Blog: Optimising Journal Line Queries: 3. Partitioning
0
0
1
The PeopleSoft DBA Blog: Optimising Journal Line Queries: 2. Exadata System Statistics .
0
0
0
The PeopleSoft DBA Blog: Optimising Journal Line Queries: 1. Problem Statement
0
0
0
The PeopleSoft DBA Blog: Logging Run Controls and Bind Variables for Scheduled PS/Queries -
0
0
0
The /*+Go-Faster*/ Oracle Blog: Configuring SQL Developer to Authenticate Via Kerberos -
0
0
2
The /*+Go-Faster*/ Oracle Blog: Locally Partitioned Unique Indexes on Reference Partitioned Tables -
0
0
4
The PeopleSoft DBA Blog: A Resource Manager CPU Time Limit for PS/Queries Executed On-line in the PIA -
0
1
2
The /*+Go-Faster*/ Oracle Blog: SQL Quarantine Behaviour When the Same SQL Executes in Different Resource Manager Consumer Groups With Different CPU Time Limits .
0
0
0
The /*+Go-Faster*/ Oracle Blog: New Parameters In 21c To Control Automatic SQL Quarantine Can Be Backported To 19c .
0
0
1
The PeopleSoft DBA Blog: Quarantined SQL Plans for PS/Queries
0
0
0
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)! 🤦♂️.
0
0
0
The PeopleSoft DBA Blog: Management of Long Running PS/Queries Cancelled by Resource Manager CPU Limit -
0
1
0
The PeopleSoft DBA Blog: SQL Profiles for Application Engine Steps that Reference Temporary Records via the %Table() Meta-SQL:
0
0
1
In the Cloud, Performance is Instrumented as Cost.- A Resource Plan for PeopleSoft . A presentation about both the Oracle database & PeopleSoft ERP from #UKOUG #UKOUGDiscover24 #UKOUG, now on the PeopleSoft DBA Blog.
0
0
1