Lutz Haake | Freelance Oracle Consultant

How network ressources change when a 3‑node RAC fails

I was wondering, so I asked — and got this beautiful graphic.
When do unified audit policies become active?

I’m learning about unified auditing on 19c, how to set it up, and how to audit…
List all hidden, non-default parameters

How to display all hidden parameters that are non-default. In this case, for a 19c single-instance. ksppstvl.ksppstdf…
SQL duration and elapsed time in parallel execution

With parallel execution, displayed values for query duration and elapsed query time differ in OMS. In SQL…
How does Oracle store code?

Looking at DBA_SOURCE, where are are those lines actually stored? SYS.DBA_SOURCE is a view that depends on…
A handy tool for searching PL/SQL code

More often than not, I need to search dba_source for specific keywords. But, you ask, how about…
Using DBMS_AUTO_REPORT to retroactively identify performance problems

Find the problematic SQL ID to investigate, then execute: col report_id new_v report_id select * from …
What is causing my ORA-1652?

ORA-1652: unable to extend temp segment by … in tablespace … Can be caused by a single TEMP-intensive query,…
How to clean up after ORA-27477

On a 2‑node RAC: WITH a AS (SELECT SYS.DBMS_QOPATCH.get_opatch_bugs bugs_output FROM DUAL) SELECT * FROM a, XMLTABLE('bugInfo/bugs/*' PASSING…
ORA-28040: No matching authentication protocol

Directly after startup, I received: SQL> startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ERROR:…