What's New in 11i TXK AutoConfig and Templates Rollup Patch S

Context You might have already seen the blog update on Steven Chan's site. TXK AutoConfig and Templates Rollup Patch S ...

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

Introduction If you have created a new Oracle 11g database using DBCA and opted to use by default 11g's enhanced ...

Moving Oracle Datafiles to a ZFS Filesystem with the Correct Recordsize

Why are your indexes larger than your actual data?

It’s a common but startling sight for any DBA: you look at your database statistics and realize your indexes are ...

3 Tips on Using dg4odbc on 64-bit Linux

I recently imported the contents of an Oracle 8i database into an 11g database. Since the original application needed ...

Linux Patching and Oracle: Detect RPM conflicts before they happen

A common scenario in the life of a DBA on a linux server looks something like this: From: Sue-the-sysadamin To:the-dba ...

Oracle block corruptions, DBV vs RMAN

Over-the-Top Tales from the Trenches Motto: Bringing order to the chaos of every day DBA life. Dear Diary, Is that a ...

Oracle: How to move a table to another schema?

Backstory A client asked me, “How can I move a table to another schema in Oracle?” The quick answer I gave him is, “not ...

Emacs Keybindings in Bash

How to Be a Command-Line Commando Does it surprise you to learn that I’m a Linux guy? I’ve been using Linux, to the ...

Aligning ASM Disks on Linux

Linux is a wonderful operating system. However there are a number of things that one needs to do to make sure it runs ...

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

Swappiness

Swappiness, as the name suggests, affects the swapping in the Linux systems. Introduction Its kind of slider value. 0 ...

Exadata smart scans and the flash cache

Context One of the key features of Exadata V2 is the flash cache. Although commonly thought of as an OLTP-specific ...

RMAN reports, or What Is the ETA of My Backup?

Introduction Over-the-Top Tales from the Trenches. Motto: Bringing order to the chaos of every day DBA life. Dear ...

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

Speeding-Up Oracle Export/Import Migration

Or, How To Become an Export/Import Migration Superstar! We’ve already established that I like broccoli. I get the taste ...

Exadata Patching Overview

Introduction Hello everyone ! For my first time posting here on the Pythian Blog, I would like to share some of my ...

Beware the /var/tmp/.oracle Hidden Directory!

Background A few months ago, we had a test instance complaining that it couldn’t write to ASM. This was an 11.1.0.7 ...

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