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 >

ORA-30926 While Using impdp Over a Database Link

The other day I was doing an import using impdp in 12.1.0.2, and received the following error:’ORA-30926: unable to get a stable set of rows in the source tables’.   Starting "SYS_PYTHIAN"."SYS_IMPORT_TABLE_03": sys_pythian/******** parfile=table_import.par Processing object type TABLE_EXPORT/TABLE/TABLE Processing object…

Read More >

Replicating Users and Tablespaces with Oracle GoldenGate

Gleb Otochkin explains how to replicate users and tablespaces using Oracle GoldenGate.

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 >

A Step-by-Step Flashback of RAC database to Restore Point

The following is the step-by-step process of Flashback of RAC database to a Restore Point. 1) Set the environment to correct instance. ps -ef | grep pmon . oraenv 2) Get restore point name and make note of it from…

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