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