This is one of the many reasons you use bind variables.
Following Up re HALP
Just a follow-up to this post. Turns out that the problem was caused by an aborted online relayout on some disk that housed our archive log destination. Rather than actually aborting, the relayout process was left in a "paused" state. After the sys admin cleared this state, performance went back... [Read More]
The Powers of Certification
On the heels of my recent OCAfication, I came across "The power of Oracle certification" which mentions this Dilbert comic that I hadn't seen and made me chuckle. Enjoy. [Read More]
Getting slammed this week. My production instance hanging for 10-15 minutes 2-3 times a day during business hours due to latching on the shared pool and library cache. Oracle "support" seems to be reading from a "fix ur app codez kthxbye" script.This post from Jonathan Lewis describes the symptoms to... [Read More]
And I had just spoken with someone last week about how TOra was dead. Then they come out with a new release.This was one of my pet projects to maintain back when I worked for Gentoo. A nice alternative to TOAD for those of us fighting to keep our linux... [Read More]