Doug Burns has a great video presentation up at the Pythian blog, in which he gives a great explanation of the basics of Oracle's parallel execution feature.It's a great video and it got my head straight on a lot of things (and just created more work for objects that I... [Read More]
For Great Justice!
This brought a wry smile to my face. Although Ujang is royally screwed, Mladen still had the presence of mind to set him up the bomb.I hope you know what I'm talking about.
Courtesy of Jonathan Lewis, I present you with LNNVL(). For those of you who forget to consider the possibility of NULL values in your query predicates, this could be a godsend. Should clean up a lot of predicates that had to use OR cases just to separately check for NULLs.As... [Read More]
Data and Datatypes
Somehow while reading through some Oracle blogs this weekend, I found myself re-reading a post from Tom Kyte last year about mis-used datatypes. Such things as people using string datatypes to hold date values, or people using VARCHAR2(4000) for every field in every table. Tom does a fantastic job (as... [Read More]
Stealing My Material: or How I Though of Blogging About v$sql_bind_capture before hali did
This past Wednesday in #oracle, I asked how one views what values are being used in a SQL statement with bind variables. hali led me to v$sql_bind_capture. We played with some joins to v$sql and v$session and all was well. I immediately recognized the blog-worthiness of the discussion and tagged... [Read More]