Tag: Oracle

Backup Oracle Databases to AWS S3

There are different options for backing up Oracle databases to Cloud, but using Oracle Secure Backup module to take backups into AWS S3 is one of the most efficient methods in terms of costs and backup/restore performance. In this post…

Read More >

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 >
Page 4 of 147« First Page...23456...10...Last Page »