Oracle Scratchpad

March 20, 2008

Humour

Filed under: Uncategorized — Jonathan Lewis @ 5:01 pm UTC Mar 20,2008

Tom Kyte and Pete Finnigan are both well known for talking about the need to use bind variables and the dangers of SQL Injection. This cartoon must have been written just for them.

ANSI SQL

Filed under: CBO, Infrastructure, Troubleshooting — Jonathan Lewis @ 4:26 pm UTC Mar 20,2008

Someone sent me an email a little while ago about a problem they were having with two databases that were using different execution plans for the same query. 

But the two databases were believed to be identical, and the optimizer was running rule-based in both cases, so it shouldn’t have been possible to get different execution plans.

(more…)

Blog at WordPress.com.