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]
Tags: oracle

HALP

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]
Tags: oracle

TORA LIVES

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]
Tags: tora oracle