OUGN : Day 1

The journey to Norway was pretty straight forward, but during the second flight, from Amsterdam to OSLO, my nose and eyes started to stream. I didn’t feel ill, but I was starting to worry I might...
0 comment

NVL() change

One of the problems of functions is that the optimizer generally doesn’t have any idea on how a predicate based on function(col) might affect the cardinality. However,  the optimizer group are...
0 comment

Unusable unique constraint

Another annoying thing about unusable indexes I’m surprised that I can’t remember coming across this before before. I want to archive some data from a bunch of partitions. Unfortunately, I...
0 comment

VIDEO: The Evolution of IT Outsourcing

“For us to understand what’s going on in the industry at large, it helps for us to have a deeper understanding of the history of the outsourcing industry.” Pythian founder, Paul Vallée...
0 comment

Log Buffer #366, A Carnival of the Vanities for DBAs

While the Oracle blogosphere is buzzing with the Collaborate news and views, SQL Server and MySQL bloggers are also getting upbeat about their respective fields and producing gems of blog posts. This Log...
0 comment

IDC White Paper – Blending Transactions and Analytics into a Single In-Memory Platform

See how a single data-management environment can help IT eliminate information delays and enable your financial institution to optimize sales by responding to current, dynamic conditions.Request Free! By:...
0 comment

A Simple Way to Monitor Java in Linux

A quick and easy way to know what is it inside Java process that is using your CPU. Using just Linux command line tools and JDK supplied command line utilities. Introduction Here are a few things you...
0 comment

Cache anomaly

Just a quick heads-up for anyone who likes to play around with the Keep and Recycle caches. In 11g Oracle introduced the option for serial direct path reads for tablescans on tables that was sufficiently...
0 comment

Use Speech Analytics in the Contact Center to Monitor Agent Performance and Improve the Customer Experience

With companies experiencing hundreds to tens of thousands of phone conversations with their customers each day, the questions arise: • Do they know what their customers really want and need?...
0 comment

Easy – Oops.

A question came up on OTN today asking for suggestions on how to enforce uniqueness on a pair of columns only when the second column was not null. There’s an easy and obvious solution – but...
0 comment