Moving Oracle Datafiles to a ZFS Filesystem with the Correct Recordsize

Oracle's OPT_ESTIMATE hint: Usage Guide

It's one of those hints that you've heard about many times, but all the information is scattered, and finding what you ...

Exadata's Best Kept Secret: Storage Indexes

While features like Smart Scan often steal the spotlight in Exadata discussions, Storage Indexes are a silent ...

AQ Notifications in Oracle 11gR1

Introduction The AQ notification process has changed from release 10gR2 to 11gR1. The most notable change is the switch ...

EBS DBA: WF Mailer Override Address and Cloning: How to

I just recently faced an issue regarding how to automate the Workflow Mailer override address for development and ...

Exadata TPC Benchmarks

Notice One of the questions in my webinar this week related to TPC benchmark results for Exadata. Kevin Closson blogged ...

Cloning Oracle Home from RAC to Stand-Alone

This should have been the easiest task on my todo list: Install Oracle 10.2.0.3 EE standalone on a new Linux RHEL 5 ...

DBD::Oracle and Windows 64bit

I have successfully compiled and installed DBD::Oracle on Windows 2008 Server 64bit operating system today. I used the ...

Emergency Recovery or RMAN DUPLICATE Rerun Just Works!

Working as a DBA often means facing high-pressure situations, especially during an on-call weekend. Recently, I was ...

Running querys against multiple SQL Server AND Oracle instances

Background It is not unusual that a DBA needs to run the same query across multiple instances. The query can be ...

HOWTO: Oracle Cross-Platform Migration with Minimal Downtime

Strategy for a Minimal Downtime Migration I recently performed a migration from Oracle 10gR2 on Solaris to the same ...

Oracle GoldenGate Installation, Part 1

I want to introduce several post about Oracle GoldenGate (GG), a relatively new replication software from Oracle. We ...

Chopt Utility

Introduction There is a new tool came with Oracle 11g Rel.2 that helps to modify options in installed oracle home ...

Oracle: Limiting Query Runtime Without Killing the Session

Recently, a customer request came in to limit the runtime of a query in a 10g database for a certain user. But since ...

Patching an 11gR2 Grid Infrastructure Home

Introduction The process for applying a patch on top of the CRS, or now called, the Grid Infrastructure, has changed ...

Oracle 11g SE Switch-Over

Recently, I tested a switchover on Oracle 11g SE1. As you know, Oracle Database Standard Edition One—as well as ...

Setting up Network ACLs in Oracle 11g… For Dummies

Having recently performed a test upgrade for a client from Oracle RDBMS 10g to 11g, I can tell you that one of the big ...

AWR Extract and Load

Introduction In preparing my presentation for the Michigan Oak Table Symposium, I came across AWR extract and load. ...

Exadata smart scans and the flash cache

Context One of the key features of Exadata V2 is the flash cache. Although commonly thought of as an OLTP-specific ...

Notes on Learning MySQL (as an Oracle DBA)

I spent some time last month getting up to speed on MySQL. One of the nice perks of working at Pythian is the ability ...

Questions you always wanted to ask about Flashback Database…

Last Friday in the Sydney Oracle Meetup I talked about Oracle Flashback technology and how it helps to reduce downtime. ...

Beware the /var/tmp/.oracle Hidden Directory!

Background A few months ago, we had a test instance complaining that it couldn’t write to ASM. This was an 11.1.0.7 ...

Installing Oracle 11gR2 Enterprise Edition on Ubuntu 10.04 (Lucid Lynx)

I recently reformatted my laptop with the latest Ubuntu LTS release, 10.04, aka Lucid Lynx. Since I like to have a ...

Designing for Exadata: Maximizing Storage Indexes Use

Oracle Exadata V2 is a very well balanced database machine combined with smart and innovative software. One of these ...

Oracle GoldenGate Extract Internals, Part III

This is the third post in the Oracle GoldenGate Extract Internals series (links to part I and part II). In this post, ...

Oracle GoldenGate Extract Internals, Part I

Since GoldenGate has been declared as a strategic direction for replication technology by Oracle, it sounds like it’s ...

ORA-01555: snapshot too old, When Running Flashback Query

Argh! Of all the frustrating, partially-completed features Oracle has released, this is the most frustrating. Did I ...

A grand tour of Oracle Exadata, Part 2

After covering hardware components of Sun Oracle Database Machine in part 1, our grand tour continues with a look at ...