Tag: Oracle

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

This edition of Log Buffer covers Oracle, Microsoft SQL Server, and MySQL.

Read More >

Parting With ocm.rsp Isn’t Really Sweet Sorrow…

Now that we’re well into 2017, let’s sit back and ask the question: “What was the best news of 2016 in the Oracle ecosystem?” The 12.2 beta ? (no, that was announced in October 2015 :)) The fact that we…

Read More >

Investigating IO performance on Amazon EC2

I published a blog post called “Investigating IO Performance on Amazon RDS for Oracle” recently, and soon after posting it I received several questions asking if IO worked the same way on EC2 instances. My immediate though was it did,…

Read More >

Investigating IO Performance on Amazon RDS for Oracle

Maris Elsins, Lead Database Consultant at Pythian, provides an in-depth examination of IO Performance on Amazon RDS for Oracle.

Read More >

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 >
Page 1 of 14412345...10...Last Page »