The /+Go-Faster/ Oracle Blog

The PeopleSoft stuff is at blog.psftdba.com.
This is the non-PeopleSoft Oracle Database blog. Mostly about performance.

Announcements

▼

Tuesday, March 18, 2025

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 ...

Tuesday, March 04, 2025

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 ...

Monday, March 03, 2025

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...

Friday, November 29, 2024

SQL Developer Tip: Exporting SQL Results to Excel by Default

I frequently use SQL queries to extract performance data from Active Session History (ASH). I often then want to graph that data. Excel is...

Friday, September 13, 2024

Purging Standard and Unified Audit Data

Introduction It is not uncommon for businesses to have policies to retain audit data for several years, but then it ought to follow that tha...

View web version

Powered by Blogger.