Tag: Oracle

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 >

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