Success is about Imagination

Embarcadero s conducting a brief survey to learn more about database professionals what challenges do they face this year and day to day...

The infamous 10053 trace is probably the most extensive trace for understanding why the Oracle optimizer chose a query’s execution path...

I’m excited about the upcoming minor release of DB Optimizer in a few weeks, 2.5.1. Version 2.5.1 will have graphics for outer joins,...

I’ll be speaking at the InSync10 event in Melbourne about Database Performance Made Easy at the InSync10 event in Melbourne, Australia 16...

New book recommendation: Refactoring SQL Applications by Stephan FaroultI found the book easy to read, well thought out and covers...

How does the STA work in 11gR2 with the query from “Oracle’s SQL Tuning Pack – part 2” ? Here is the view on the Top Activity Page: The...

Above its the load produced by the same load. Its a query being run by 10 users 20 times with a sleep of random interval between 1-2...

Have you used Oracle’s SQL Tuning Pack? What were your experiences like? At my last consulting gig 2 out 3 statements I “tuned” with the...

We had almost 2000 people sign up for the webinar on SQL tuning with Jonathan Lewis and I. After the webinar many people had questions on...

(Via Slashdot http://developers.slashdot.org/story/10/06/14/2225251/Knuth-Got-It-Wrong) Full article at http://queue.acm.org/detail.cfm?i...

Thanks to everyone who joined for the webinar with Jonathan Lewis last Thursday. I’ve been getting a number of inquiries asking if the...

Anyone who has been around Oracle performance over the years knows the grief that hard parsing SQL queries can cause on highly concurrent...

Just got DB Optimizer 2.5 out the door two weeks ago and now work is going fast on 2.5.1 slated for beginning of August. Already added...

(original at http://sites.google.com/site/embtdbo/tuner/oracle-tcf-query-and-lios-per-row) Based on the idea by Wolfgang Breitling that...

Just found this one http://www.oracle.com/technology/obe/demos/admin/demos.html video demos of Oracle features – pretty cool. For example...

There is a way to connect to Oracle even when sessions are maxed out or there is a hang etc: I knew about this a while back but its just...

Register for the live webinar on June 10th here: http://www.embarcadero.com/master-sql-tuners-oracle-lewis-hailey Tune in for the...

Can you figure out what this chart is trying to say? I have a hard time of it: Here is the data laid out in a more compelling manner: I...

UPDATE: register for webinar at http://www.embarcadero.com/master-sql-tuners-oracle-lewis-hailey Stay tuned for a live free webinar on...

Sometimes, it is a great idea to push away the keyboard when tackling the problems of an ill-performing, complex, query, and take up...