Oracle 11g: New Pivot Table Feature
I was very pleased when I heard about Oracle adding pivot functionality in select statements....
Pythian Blog: Data Analytics, Cloud Computing, and Database Management (164)
Oracle 11g's Query Result Cache -- Introducing the RC Enqueue
Way before 11G made its way to production, I joked that this new feature called Query Result Cache...
Oracle 11g's SQL Performance Analyzer
A lot of things have already been said about the Real Application Testing Option -- from the price...
Oracle Standby redo Logs
So you have created your standby database using the RMAN DUPLICATE command, you have set the...
Tuning Pack 11g : Real-Time SQL Monitoring
“Real Time SQL Monitoring” is a 11g Tuning Pack new feature. You can easily access it when the...
Oracle file extent map, the old-fashioned way
Have you ever wanted to know where exactly in a datafile segments are placed? Have you ever...
Total Recall by DUDE: Extracting Oracle Data After RAID Corruption
Last Friday, a customer paged me to say that they could not open an Oracle 8.0.5 database after the...
SELECT COUNT(*) FROM Tab -> No Rows Selected
In the following SQL*Plus output… SQL> select sum(tran_sum), count(*) 2 from trans; no rows...
MERGE Without an INSERT -- It's Not Always Like an UPDATE
Before you proceed with reading this post, I strongly encourage you to read Tom Kyte's trilogy...
An Open Letter to Larry Ellison on AWR and ASH Licensing
15 years ago, with the release of Oracle 7.0.12, Oracle gave the world—or at least its...
