This is the first of three blogs about using Data Pump on an Autonomous Oracle database.   General considerations and setup . Export Import ...

This blog is part of a  series  about aspects and features of Oracle 26 and Autonomous Transaction Processing Database. I have created a tra...

This blog is part of a  series  about aspects and features of Oracle 26 and Autonomous Transaction Processing Database. As a training exerci...

This blog is part of a  series  about aspects and features of Oracle 26 and Autonomous Transaction Processing Database. I have created a tra...

This blog is part of a  series  about aspects and features of Oracle 26 and Autonomous Transaction Processing Database. "JSON (JavaScript Ob...

This blog is part of a series about aspects and features of Oracle 26 Autonomous Transaction Processing Database. TL;DR This is an opinion ...

This blog is part of a  series  about aspects and features of Oracle 26 Autonomous Transaction Processing Database. I have written about us...

This post is the last part in a series that discusses the use of job classes with the Oracle database scheduler. Job Classes and the Databa...

This post is the second part in a series that discusses the use of job classes with the Oracle database scheduler. Job Classes and the Data...

This post is the first part in a series that discusses the use of job classes with the Oracle database scheduler. Job Classes and the Data...

The purpose of object statistics is to inform the cost-based optimizer about the size and shape of your data, enabling it to make informed d...

A blog about PeopleSoft, Oracle database, and performance tuning

I discussed locally partitioning the unique index on reference partitioned table in a previous blog .  Having implemented it, I wanted to co...

A blog about PeopleSoft, Oracle database, and performance tuning

Oracle have provided a very detailed note Troubleshooting "ORA-00060 Deadlock Detected" Errors (Doc ID 62365.1) .   This document includes a...

A blog about PeopleSoft, Oracle database, and performance tuning

A blog about PeopleSoft, Oracle database, and performance tuning

A blog about PeopleSoft, Oracle database, and performance tuning

A blog about PeopleSoft, Oracle database, and performance tuning

A blog about PeopleSoft, Oracle database, and performance tuning

A blog about PeopleSoft, Oracle database, and performance tuning

Kerberos is a trusted third-party authentication system that relies on shared secrets and presumes that the third party is secure (see  Orac...

Normally, if you want to locally partition a unique index, you must include the partitioning key in the index key. Otherwise, you get will ...

A blog about PeopleSoft, Oracle database, and performance tuning

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

SQL Quarantine is only available on Exadata.  In 19c, automatic quarantine generation and subsequent use are enabled by default.   In Oracle...

A blog about PeopleSoft, Oracle database, and performance tuning

A blog about PeopleSoft, Oracle database, and performance tuning

A blog about PeopleSoft, Oracle database, and performance tuning

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.

A blog about PeopleSoft, Oracle database, and performance tuning

Read Consistency: Why You Need it and How to Avoid it - Download as a PDF or view online for free

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

A blog about PeopleSoft, Oracle database, and performance tuning

A blog about PeopleSoft, Oracle database, and performance tuning