Success is about Imagination

Did you know that Oracle only joins one table at a time? As Dan Tow puts in his book “SQL Tuning“ [Oracle] simply takes what it’s got at...

Outer Joins If English and French both have a unique key on the “ordinal_id” then it’s basically one-to-one relationship We add an arrow...

How would you go about tuning a query like this? SELECTa0.af1,a0.af2,a0.af3,c.af4,e.ef1,FROMa a0,(SELECT a1.af5, a1.af6, a1.af1,...

When i was working on OEM, one of my many pet peaves was the size of browser pages, wasted space and data below the “fold line”. Here is...

One goal I have over the next couple months is creating organized documentation on Oracle Wait events. One event, os-thread-startup, is...

Three important factors to take into account in performance tuning of database operations: · Automation · Methodology · Collaboration...

Presented with Forrester’s Noel Yuhanna. Noel presented on the trends that are effecting performance, why it is critical to maintain...

Wow, I’m amazed and thrilled at all the press that DB Optimizer 2.0 is getting in the press. Check this out: SD Times Infoworld Codebeach...

http://www.hotsos.com/sym10/sym_speakers_hailey.html Advances in SQL Tuning Techniques In the past few years some novel SQL tuning...

According to the picture superiority effect, concepts are much more likely to be remembered experientially if they are presented as...

This is more of a bookmark for a future blog post on using the Cardinality hint. This post by Greg Rahn give some example and I posted in...

A good part of my presentation Friday at NoCOUG was on explain plan command being an estimate of the actual execution plan. Now on the...

I was talking to someone from Amazon who indicated that Amazon is moving more and more processing away from Oracle into the middle tier...

Ever have problems de-installing software on windows? Well Embarcadero has a new technology where there is no install for it’s windows...

Had an enjoyable day at the NoCOUG held at Oracle Corp, my old stomping grounds. It was fun to see and catch up with Greg Rahn, John...

Did you know Google books has some amazing Oracle resources on line? I’m giving a presentation tomorrow at the Northern California Users...

this site http://kerryosborne.oracle-guy.com/2009/04/oracle-11g-sql-plan-management-sql-plan-baselines is the best source of information...

here is a feature that I’m excited about: Real Time SQL Monitoring http://askdba.org/weblog/2009/09/11gr2-monitoring-real-time-sql-plan-e...

Nice article on DB Optimizer: Taking the black art out of SQL tuning by Martin Heller Embarcadero DB Optimizer 2 takes a methodical...

Ever wonder why some of those DBA_ views take so long to execute? here is the view expansion of a query from SYS.DBA_ALL_TABLES joined...