Tag: Oracle

Enqueue Bytes – Is that a Pun?

Jared Still explains how to troubleshoot enqueue locking events in Oracle databases.

Read More >

Distinguish Real SQL Execution Plans from Fake Ones!

Oracle database consultant Mohammad Faisal demonstrates various SQL execution plan extraction methods.

Read More >

AWS DMS Tips for Oracle Migrations

Explore AWS DMS, and discover tips for Oracle Migrations.

Read More >

While upgrading to 12.1.0.2 I faced error ORA-01830 / ORA-06512

The other day I was running an upgrade for a client that is using ACLs ( Access Control Lists) from 11.2.0.3 to 12.1.0.2. If you have been doing upgrades to 12c, you know that when running the catctl.pl -n 4 catupgrd.sql it…

Read More >

Oracle Service Secrets: Migrate Transparently

In the third post in this series, Bjoern Rost, Principal Consultant at Pythian, explains how to migrate transparently using Oracle services.

Read More >

Oracle Service Secrets: quiesce tactically

In the second post in this series, Bjoern Rost, Principal Consultant at Pythian, explains how to temporarily disable connections during maintenance with the help of services.

Read More >

The rlwrap utility for DBA.

I spend most of my time as a DBA in linux terminal and sqlplus. Everybody who works with oracle sqlplus knows about its power, but also about its limitations. For many years I have used the rlwrap utility developed by…

Read More >

ORA-15418: Appliance Mode Not Supported For Compatible.asm 12.1.0.0.0

Fred Denis, Pythian Oracle Database Expert, talks about his encounter with error code ORA-15418: on 12.1 on Exadata.

Read More >

Truncates and Sequences Replication in Oracle GoldenGate

Gleb Otochkin, Principal Consultant and Certified Oracle Expert at Pythian, discusses the truncate operation and support for sequences values replication.

Read More >

Log Buffer #482: A Carnival of the Vanities for DBAs

Fahd Mirza, Oracle Database Administrator at Pythian, highlights top blogs posts in the worlds of Oracle, SQL Server and MySQL.

Read More >
Page 1 of 14412345...10...Last Page »