SQL Server: More light shed on "non-yielding scheduler" and Indexes stats

SQL server folks may find the "non-yielding scheduler" warning familiar and it is usually (if not always) associated ...

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

DBD::Oracle and Windows 64bit

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

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

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

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

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

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

Check URL status from SQL server

One of our clients has a public web page and they needed to ensure that it is always up and accessible. Pythian already ...

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

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

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

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

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

Oracle: What is an Unrecoverable Data File?

A data file is considered unrecoverable if an unrecoverable operation has been performed on an object residing in the ...

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