Oracle

Tanel Poder had a great post about bind variable peeking, http://blog.tanelpoder.com/2010/02/02/bind-variable-peeking-execution-plan-inefficiency/  I run into this exact issue more often than

The Lead Developer and I have been working very, very hard on tuning the main process that produces much of

I’ve come to realize that most folks don’t really understand the limitations in the allocation of PGA memory to hashing

I’m preparing to build our new 11g environment and as I “study up” on all that is new in 11g,

After a lovely week off, I came back into work and brought up the OEM console to take a quick

Two weeks ago, after a new mart had performed excellent for 24hrs, a sudden and detrimental decline in performance was

…also known as follow up post on “dropping unused columns…” In my last post I discussed how to drop unused

A developer needed to do some serious data changes to a partition. I thought I’d be a helpful DBA and

A developer friend of mine sent me an email today frustrated that none of the DBA’s he worked with could

The Challenge: You want one process in your application to use a separate temp tablespace created on faster “ram disks”

This is a subject that I see a lot of debate on, but as a DBA who works in mostly

You have a statement that somebody, without thinking about resources, requested 96 total parallel processes for. They have now come

OEM Reports that a server load is critical and top confirms this- PID USER PR NI VIRT RES SHR S

method_opt=>’for all columns size 1′ This is the method option for DBMS_STATS.GATHER_TABLE_STATS that is commonly recommended- “Let Oracle look at