How to Recover Deleted Oracle Datafiles with No Downtime
So you have accidentally removed a datafile from your production database? First thing, DON’T...
Pythian Blog: Data Analytics, Cloud Computing, and Database Management | Christo Kutrovsky (3)
Aligning ASM Disks on Linux
Linux is a wonderful operating system. However there are a number of things that one needs to do to...
Sequences in Oracle 10g RAC
Just recently I got a call from a developer. He had a table with a primary key populated by a...
Oracle RAC Cache Fusion Efficiency: A Buffer Cache Analysis
My apologies — there will be no broccoli in this post. Many people would like to know how well...
Oracle Support Case Studies
As I was poking around metalink, I found the following extremely interesting section. It’s in a...
Oracle: How to move a table to another schema?
A client asked me, “How can I move a table to another schema in Oracle?” The quick answer I gave...
Oracle 10g R2 RAC - vip on wrong interface
I was installing RAC, and during the clusterware install I picked up the wrong interfaces for...
ASM multi-disk performance
If you have the ability to combine disk spindles at both the SAN level and Oracle (ASM) level,...
