Tag: Oracle

Reading Execution Plans for Parallel DML

Parallel execution in Oracle seems to be a topic of myths, mysteries and misunderstandings. In this post I hope to clear up at least one of them by diving into a discussion about parallel DML. Actually, I want to show…

Read More >

Oracle New Public Cloud Licensing Policy – Good or Bad?

A little while ago after a question from a customer about supporting Oracle products on the Google Cloud Platform (GCP) I decided to take a look for any updates to the Oracle public cloud support policies. The document can be…

Read More >

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

This Log Buffer Edition searches through various blogs of Oracle, SQL Server and MySQL and picks a few contemporary ones.

Read More >

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