Featured blog posts

Hadoop FAQ - But What About the DBAs?

Hadoop FAQ - But What About the DBAs?

Jan 25, 2013 12:00:00 AM 5 min read
The Easy Way of Finding Similar SQL Statements

The Easy Way of Finding Similar SQL Statements

Jan 24, 2013 12:00:00 AM 3 min read
Are You Switching to BULK_LOGGED Recovery Model? Know Your Risks.

Are You Switching to BULK_LOGGED Recovery Model? Know Your Risks.

Jan 13, 2013 12:00:00 AM 6 min read
Build an 11gR2 RAC Cluster in VirtualBox in 1 Hour Using OVM Templates

Build an 11gR2 RAC Cluster in VirtualBox in 1 Hour Using OVM Templates

Dec 21, 2012 12:00:00 AM 19 min read
Sleuthing for Temporary Space Spendthrifts

Sleuthing for Temporary Space Spendthrifts

Dec 20, 2012 12:00:00 AM 4 min read
Revealing the Hints Behind the Automatic SQL Tuning Advisor

Revealing the Hints Behind the Automatic SQL Tuning Advisor

Dec 13, 2012 12:00:00 AM 3 min read
EBS: R12 Default OACORE Memory Settings Are Not Enough

EBS: R12 Default OACORE Memory Settings Are Not Enough

Dec 10, 2012 12:00:00 AM 2 min read
Changing SID on a RAC Environment

Changing SID on a RAC Environment

Dec 7, 2012 12:00:00 AM 1 min read
Temporary Tablespaces: to BIGFILE or Not to BIGFILE

Temporary Tablespaces: to BIGFILE or Not to BIGFILE

Dec 5, 2012 12:00:00 AM 3 min read
Build an EBS 12.1.3 Sandbox in VirtualBox in 1 Hour

Build an EBS 12.1.3 Sandbox in VirtualBox in 1 Hour

Nov 29, 2012 9:03:00 AM 34 min read
Read GoldenGate Discard Files

Read GoldenGate Discard Files

Nov 26, 2012 12:00:00 AM 6 min read
Upgraded to 11GR2? Congrats! You Are in Direct Reads Trouble!

Upgraded to 11GR2? Congrats! You Are in Direct Reads Trouble!

Nov 14, 2012 12:00:00 AM 5 min read
Case Study: How to Return a Good SQL Execution Plan from 10g Days After an 11g Migration

Case Study: How to Return a Good SQL Execution Plan from 10g Days After an 11g Migration

Nov 12, 2012 12:00:00 AM 3 min read
Yury, Remember: This is How You Disable AUTO_TASKs in 11G

Yury, Remember: This is How You Disable AUTO_TASKs in 11G

Nov 11, 2012 12:00:00 AM 3 min read
RMAN: Corrupt Block? Let's Re-Read... Nope, It's All Good

RMAN: Corrupt Block? Let's Re-Read... Nope, It's All Good

Nov 8, 2012 12:00:00 AM 2 min read
Are There Performance Penalties Running Oracle ASM on NFS?

Are There Performance Penalties Running Oracle ASM on NFS?

Nov 6, 2012 12:00:00 AM 4 min read
Analyzing SQL Server Data File Anatomy

Analyzing SQL Server Data File Anatomy

Nov 2, 2012 12:00:00 AM 13 min read
Select Statement Generating Redo and Other Mysteries of Exadata

Select Statement Generating Redo and Other Mysteries of Exadata

Oct 30, 2012 12:00:00 AM 5 min read
Reasons to Use ASM on NFS

Reasons to Use ASM on NFS

Oct 28, 2012 12:00:00 AM 2 min read
Oracle Direct NFS Configuration File Explained

Oracle Direct NFS Configuration File Explained

Oct 28, 2012 12:00:00 AM 2 min read
DUPLICATE from ACTIVE Database Using RMAN, a Step-by-Step Guide

DUPLICATE from ACTIVE Database Using RMAN, a Step-by-Step Guide

Oct 24, 2012 12:00:00 AM 4 min read
Repost: Oracle Protocol

Repost: Oracle Protocol

Oct 23, 2012 12:00:00 AM 22 min read
DNFS: wtmax = /proc/fs/nfsd/max_block_size

DNFS: wtmax = /proc/fs/nfsd/max_block_size

Oct 22, 2012 12:00:00 AM 3 min read
Adding Networks to Exadata: Fun with Policy Routing

Adding Networks to Exadata: Fun with Policy Routing

Oct 15, 2012 12:00:00 AM 4 min read
What Should We Store on Hadoop?

What Should We Store on Hadoop?

Oct 3, 2012 12:00:00 AM 3 min read
Exadata Eighth Rack: A Few Thoughts

Exadata Eighth Rack: A Few Thoughts

Oct 1, 2012 12:00:00 AM 2 min read
Bulk Loading Options for Cassandra

Bulk Loading Options for Cassandra

Sep 24, 2012 12:00:00 AM 3 min read
Troubleshooting ORA-27090 Async I/O Errors with Systemtap

Troubleshooting ORA-27090 Async I/O Errors with Systemtap

Sep 20, 2012 12:00:00 AM 5 min read
How to Move Master Database to a New Location in SQL Cluster

How to Move Master Database to a New Location in SQL Cluster

Sep 11, 2012 12:00:00 AM 1 min read
Flashback and Forth

Flashback and Forth

Aug 27, 2012 12:00:00 AM 9 min read