Oracle

November 21, 2022 Martin Schmitter

Interview: Oracle 11gR2 nach 19c migrieren

Interview: Migration von 11.2 auf 19c – von Single Instance zur CDB/PDB

Abstract database monitoring illustration showing background process activity and rising memory pressure related to Oracle 19.12 EMON PGA usage.

February 9, 2022 Martin Schmitter

Oracle 19.12 EMON large consumption of PGA memory

How to troubleshoot excessive PGA memory usage by Oracle 19.12 EMON/Q processes after the July 2021 RU, including AQ queue checks and the DBMS_AQADM workaround.

Illustration of Oracle RAC maintenance where client sessions are disconnected from a node in maintenance and service traffic continues on the active node.

September 7, 2021 Martin Schmitter

Disconnect Oracle Database Sessions with srvctl and DBMS_SERVICE

How to disconnect long-running Oracle database sessions during RAC maintenance using srvctl stop service and DBMS_SERVICE.DISCONNECT_SESSION.

Illustration of Oracle RAC connection pooling with load balancing across cluster nodes and a failover path to an available node.

November 21, 2013 Martin Schmitter

Oracle Real Application Cluster: Connecting and using RAC

Eine wiederveröffentlichte DOAG-2013-Präsentation über Oracle RAC, Load Balancing, Failover und die richtige Nutzung von RAC-Verbindungsmechanismen auf Anwendungsebene.