So sayeth John Paul Jones (not this one), so sayeth I.I've been taking steps to make sure my developers know of the many benefits of using bind variables, and the punishments for not using bind variables. This is paying off in the newer code coming out, but it will take... [Read More]
PGA: Not just for Caddyshack 2 fans
Ahh ... Jackie Mason. The poor man's Rodney Dangerfield. The pride of Sheboygan, Wisconsin (other than meat products).But, no, today I'm not talking about golf (nor will I ever, if I can help it). I'm talking about Oracle's PGA, the Program Global Area. The PGA is a private chunk of... [Read More]
IT'S THE JOIN[T]!
See what I did there? 5 points to anyone who can name the reference. 10 points if you can name the original reference that I wasn't even thinking of. Void where prohibited.Sachin, broadcasting live from his blog Oracle Online Help, has posted a nice primer on the differences between three... [Read More]
I'm on the clock ...
Padraig O'Sullivan has posted the latest edition of Pythian's Log Buffer, a weekly recap of Oracle blogger activity. The Pythian Group has been letting various bloggers host the Log Buffer from week-to-week. This next week (ending 6 April), I'll be hosting the Log Buffer. This also means I'll have to... [Read More]
Appreciating Oracle's Read Consistency
One of the Oracle blogs in my feed reader linked to a post by Jeremy Schneider covering Oracle's read consistency and multiversioning. Jeremy linked to an article that Tom Kyte wrote for Oracle magazine late in 2005 about the subject. Frankly it had me dazed ... and slightly frightened.I've become... [Read More]