Featured blog posts

How to Tie OS-level PIDs to Oracle Database Sessions

How to Tie OS-level PIDs to Oracle Database Sessions

Sep 16, 2008 12:00:00 AM 3 min read
Critical security vulnerability in SQL Server 2005 announced

Critical security vulnerability in SQL Server 2005 announced

Sep 10, 2008 12:00:00 AM 1 min read
How to Find Objects Creating nologging Changes

How to Find Objects Creating nologging Changes

Sep 4, 2008 12:00:00 AM 4 min read
What Data Type is Returned by a Mathematical Function?

What Data Type is Returned by a Mathematical Function?

Aug 27, 2008 12:00:00 AM 3 min read
Oracle Silent Mode, Part 8: Add a Node to a 11.1 RAC Database

Oracle Silent Mode, Part 8: Add a Node to a 11.1 RAC Database

Aug 27, 2008 12:00:00 AM 4 min read
Does Oracle's Block Change Tracking File Shrink?

Does Oracle's Block Change Tracking File Shrink?

Aug 21, 2008 12:00:00 AM 2 min read
Multi-Node to Single-Node Cloning in R12 and 11i

Multi-Node to Single-Node Cloning in R12 and 11i

Aug 21, 2008 12:00:00 AM 1 min read
mysqlbinlog Tips and Tricks

mysqlbinlog Tips and Tricks

Aug 18, 2008 12:00:00 AM 4 min read
Consistent Gets not the Best Way to Look at Query Performance

Consistent Gets not the Best Way to Look at Query Performance

Aug 13, 2008 12:00:00 AM 2 min read
Minimize Downtime When Moving to a New SQL Server Environment

Minimize Downtime When Moving to a New SQL Server Environment

Aug 11, 2008 12:00:00 AM 4 min read
Adding a Unique Constraint on a Table with Duplicate Data

Adding a Unique Constraint on a Table with Duplicate Data

Aug 8, 2008 12:00:00 AM 3 min read
How Do You Edit a dump/exp/script File?

How Do You Edit a dump/exp/script File?

Aug 5, 2008 12:00:00 AM 1 min read
Using mysqld_multi to Manage Multiple Servers

Using mysqld_multi to Manage Multiple Servers

Jul 30, 2008 12:00:00 AM 3 min read
DNS Setup for Effective 11i DR Failover

DNS Setup for Effective 11i DR Failover

Jul 28, 2008 12:00:00 AM 3 min read
MySQL Back to Basics: Analyze, Check, Optimize, and Repair

MySQL Back to Basics: Analyze, Check, Optimize, and Repair

Jul 25, 2008 12:00:00 AM 7 min read
Tuning Latch Contention: Cache-buffers-chain latches

Tuning Latch Contention: Cache-buffers-chain latches

Jul 25, 2008 12:00:00 AM 11 min read
Which DBD::Oracle Version is for Me?

Which DBD::Oracle Version is for Me?

Jul 24, 2008 12:00:00 AM 2 min read
Oracle R12 Certified for Linux 64-bit on the x86_64 Platform

Oracle R12 Certified for Linux 64-bit on the x86_64 Platform

Jul 15, 2008 12:00:00 AM 1 min read
Oracle Silent Mode, Part 6: Removing a Node From a 10.2 RAC

Oracle Silent Mode, Part 6: Removing a Node From a 10.2 RAC

Jul 9, 2008 12:00:00 AM 10 min read
ORA-01450 During Online Index Rebuild

ORA-01450 During Online Index Rebuild

Jul 4, 2008 12:00:00 AM 2 min read
Oracle 11g -- Audit Enabled by Default, But What About Purging?

Oracle 11g -- Audit Enabled by Default, But What About Purging?

Jul 3, 2008 12:00:00 AM 2 min read
Tuning 'log file sync' Event Waits

Tuning 'log file sync' Event Waits

Jun 27, 2008 12:00:00 AM 11 min read
Differences Between innodb_data_file_path and innodb_file_per_table

Differences Between innodb_data_file_path and innodb_file_per_table

Jun 20, 2008 12:00:00 AM 2 min read
What Does GA (General Availability) Mean?

What Does GA (General Availability) Mean?

Jun 19, 2008 12:00:00 AM 1 min read
Oracle Silent Mode, Part 3: Cloning Software and Databases

Oracle Silent Mode, Part 3: Cloning Software and Databases

Jun 19, 2008 12:00:00 AM 7 min read
Oracle Silent Mode, Part 2: Patching 10.2 And 11.1 Databases

Oracle Silent Mode, Part 2: Patching 10.2 And 11.1 Databases

Jun 18, 2008 12:00:00 AM 6 min read
Oracle 11g ASM Diskgroup Compatibility

Oracle 11g ASM Diskgroup Compatibility

Jun 18, 2008 12:00:00 AM 4 min read
Oracle Silent Mode, Part 1: Installation Of 10.2 And 11.1 Databases

Oracle Silent Mode, Part 1: Installation Of 10.2 And 11.1 Databases

Jun 6, 2008 12:00:00 AM 18 min read
FLASHBACK TABLE vs. DBA_OBJECTS . LAST_DDL_TIME

FLASHBACK TABLE vs. DBA_OBJECTS . LAST_DDL_TIME

Jun 6, 2008 12:00:00 AM 3 min read
Emacs Keybindings in Bash

Emacs Keybindings in Bash

Jun 2, 2008 12:00:00 AM 2 min read