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

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

MySQL Memory Consumption

Identifying the Gaps in MySQL Memory Monitoring Had an interesting situation come up today with a client. We had 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, ...

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 Access MySQL from Oracle With ODBC and SQL

The Oracle gateway for ODBC provides an almost seamless data integration between Oracle and other RDBMS. I won’t argue ...

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

What Exactly is Swappiness?

This is an issue that keeps rearing its ugly head over and over again, and since it greatly affects performance, it is ...

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

Using the Sphinx Search Engine with MySQL

MySQL Full Text Search Limitations Suppose you have a MyISAM table containing a column with a full text index. This ...

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

MySQL on Debian and Ubuntu

Introduction Debian Linux (the underlying foundation of Ubuntu) manages the startup/shutdown of MySQL quite differently ...

T-SQL Script: Return Replication Info, Plus Undistributed Commands

In SQL Server Replication, a regular check is getting the number of undistributed commands for a transactional ...

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

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