Oracle Silent Mode, Part 9: Remove a Node from an 11.1 RAC database

This 9 th post will describe how to remove a node from a 11.1 RAC cluster in silent mode. It will differ from the ...

Quick Install Guide for Oracle 10g Release 2 on Mac OS X Leopard & Snow Leopard

I was very surprised that Oracle released Oracle Database for Mac OSX, especially, version 10g now that 11g has been ...

Moving Oracle Datafiles to a ZFS Filesystem with the Correct Recordsize

Does Oracle's Block Change Tracking File Shrink?

Intro Just a quick post to get myself back into blogging mode. Recently in IRC ( #oracle on freenode, to be precise), a ...

AQ Notifications in Oracle 11gR1

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

How to Dynamically Call PL/SQL Procedure in Oracle

Dynamic procedure calls in Oracle PL/SQL Just got an interesting note on Twitter that you can’t call a stored procedure ...

How To Choose Your Oracle Database ID (DBID)

You can choose a DBID when you rename your Oracle database. This is probably a bad, unsupported, and useless idea. I ...

Adding Columns with Default Values and Not Null in Oracle 11g

Oracle 11g has a new performance enhancement when adding columns. In the pre-11g releases, adding a new not null column ...

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 ...

Testing a Physical Standby Database in Oracle 10g

If you don’t want to deal with missteps, I recommend that you test your standby database to facilitate the failover or ...

JSP Cache Issues in 11i and R12

As an Apps DBA, you might have been asked to clear the JSP cache many times, either by Developers or Oracle Support. ...

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 Silent Mode, Part 8: Add a Node to a 11.1 RAC Database

The process of adding a node to a 11.1 RAC is very similar to the 10.2 process described in Part 5 of this series. For ...

How to Find Objects Creating nologging Changes

In an Oracle-l thread, this question was raised: how can you find objects creating nologging changes? First, what is a ...

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 ...

ORA-16069? You May Need A New Standby Controlfile

Backstory: On a recent Monday, I had to perform an emergency Oracle standby switchover for a client whose primary ...

Performance Tuning: HugePages in Linux

Recently we quickly and efficiently resolved a major performance issue with one of our New York clients. In this blog, ...

Standby Log Apply Elapsed Time

This has been discussed before by my colleague Paul Moen in his article on Oracle standby recovery rate monitoring, but ...

How to Tie OS-level PIDs to Oracle Database Sessions

About once a week, our team gets a request from the server admins to provide some information on why a database server ...

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 ...

Oracle Performance Issue: High Kernel-Mode CPU Usage

Recently, I resolved a performance issue with one of our esteemed clients. I found the problem interesting and worth ...

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 ...

How to become an Oracle Certified Master (OCM)

A turning point in a DBA’s career is when he/she is recognized by Oracle as an elite Oracle professional. I was happily ...

Killing an Oracle Job Dead

If you ever thought it was easy to kill an Oracle job, let me show you something that gave me a headache today. We’re ...

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. ...

Oracle: Delete and Re-Insert a Row in the Same Statement

It’s probably worth some explanation to understand where I want to drive you: when you run an update in Oracle, the ...

Consistent Gets not the Best Way to Look at Query Performance

This post is for those who think Consistent Gets is the only thing that matters. It’s not. That’s why Statspack and AWR ...

Setting up Virtual Hosts for Database and Applications Tiers in 11i

I would like to share with you the virtual hosts set-up (two nodes each on the application tier, and two on the DB ...

Oracle E-Business Suite: Querying Patches, Part 2

In the first part of this blog I tried to shed some light on EBS patch terminology and naming conventions. In this ...

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 ...