Featured blog posts

How to find out the machine ID on various UNIXes

How to find out the machine ID on various UNIXes

Nov 21, 2007 12:00:00 AM 1 min read
Oracle standard edition has no multi-core licensing restrictions

Oracle standard edition has no multi-core licensing restrictions

Nov 12, 2007 12:00:00 AM 1 min read
How to Recover Deleted Oracle Datafiles with No Downtime

How to Recover Deleted Oracle Datafiles with No Downtime

Nov 7, 2007 12:00:00 AM 7 min read
Installing Oracle 11g on Ubuntu Linux 7.10 (Gutsy Gibbon)

Installing Oracle 11g on Ubuntu Linux 7.10 (Gutsy Gibbon)

Nov 6, 2007 12:00:00 AM 12 min read
Using DBMS_SYS_SQL to Execute Statements as Another User

Using DBMS_SYS_SQL to Execute Statements as Another User

Nov 5, 2007 12:00:00 AM 2 min read
Oracle Outside In Technology 8.2.0

Oracle Outside In Technology 8.2.0

Nov 2, 2007 12:00:00 AM 2 min read
Oracle 11g: New Pivot Table Feature

Oracle 11g: New Pivot Table Feature

Oct 10, 2007 12:00:00 AM 5 min read
Oracle 11g's Query Result Cache -- Introducing the RC Enqueue

Oracle 11g's Query Result Cache -- Introducing the RC Enqueue

Aug 27, 2007 12:00:00 AM 4 min read
Oracle 11g's SQL Performance Analyzer

Oracle 11g's SQL Performance Analyzer

Aug 16, 2007 12:00:00 AM 5 min read
Oracle Standby redo Logs

Oracle Standby redo Logs

Aug 15, 2007 12:00:00 AM 3 min read
Tuning Pack 11g : Real-Time SQL Monitoring

Tuning Pack 11g : Real-Time SQL Monitoring

Aug 14, 2007 12:00:00 AM 4 min read
Oracle file extent map, the old-fashioned way

Oracle file extent map, the old-fashioned way

Jul 30, 2007 12:00:00 AM 9 min read
Total Recall by DUDE: Extracting Oracle Data After RAID Corruption

Total Recall by DUDE: Extracting Oracle Data After RAID Corruption

Jul 13, 2007 12:00:00 AM 3 min read
SELECT COUNT(*) FROM Tab -> No Rows Selected

SELECT COUNT(*) FROM Tab -> No Rows Selected

Jul 11, 2007 12:00:00 AM 4 min read
MERGE Without an INSERT -- It's Not Always Like an UPDATE

MERGE Without an INSERT -- It's Not Always Like an UPDATE

Jun 29, 2007 12:00:00 AM 4 min read
An Open Letter to Larry Ellison on AWR and ASH Licensing

An Open Letter to Larry Ellison on AWR and ASH Licensing

Jun 29, 2007 12:00:00 AM 4 min read
Can "between" and ">= and <=" Differ in Oracle?

Can "between" and ">= and <=" Differ in Oracle?

Jun 22, 2007 12:00:00 AM 2 min read
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE in Oracle 10g

REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE in Oracle 10g

Jun 18, 2007 12:00:00 AM 1 min read
ORA-01206: File is not part of this database - wrong database id

ORA-01206: File is not part of this database - wrong database id

Jun 15, 2007 12:00:00 AM 1 min read
What Happens When You Leave an Oracle Database in Backup Mode

What Happens When You Leave an Oracle Database in Backup Mode

Jun 13, 2007 12:00:00 AM 2 min read
Changing Hostnames in Oracle RAC

Changing Hostnames in Oracle RAC

Jun 11, 2007 12:00:00 AM 9 min read
Database sharding and the end of RAID?

Database sharding and the end of RAID?

Jun 7, 2007 12:00:00 AM 1 min read
Oracle: Standby Automatic File Management

Oracle: Standby Automatic File Management

May 30, 2007 12:00:00 AM 2 min read
Block Change Tracking Internals: X$ Tables Research

Block Change Tracking Internals: X$ Tables Research

May 23, 2007 12:00:00 AM 5 min read
plus archivelog' and RMAN optimization

plus archivelog' and RMAN optimization

May 17, 2007 12:00:00 AM 1 min read
Reporting Space-Wasting Objects in Oracle

Reporting Space-Wasting Objects in Oracle

May 1, 2007 12:00:00 AM 7 min read
The Dirty Dozen #10: Stress

The Dirty Dozen #10: Stress

Apr 30, 2007 12:00:00 AM 6 min read
MySQL Memory Usage Profile Script

MySQL Memory Usage Profile Script

Apr 18, 2007 12:00:00 AM 5 min read
Aligning ASM Disks on Linux

Aligning ASM Disks on Linux

Mar 30, 2007 12:00:00 AM 4 min read
The Dirty Dozen #1: Lack of Communication

The Dirty Dozen #1: Lack of Communication

Mar 28, 2007 12:00:00 AM 4 min read