RE: troubleshooting hangs & endless loops in Oracle

From: <>
Date: Tue, 12 Feb 2008 09:29:15 -0500
Message-ID: <>


I would like this as well if you do not mind. I have this exact trouble last week, solved with a restart. Analysis is still ongoing, and a little practice scenarios would be welcome. I can't make it to Hotsos.

Joel Patterson
Database Administrator
904 727-2546

-----Original Message-----

[] On Behalf Of Tanel Poder Sent: Tuesday, February 12, 2008 8:59 AM To: 'Oracle L'
Subject: troubleshooting hangs & endless loops in Oracle


I'm looking for ways to hang/crash an Oracle process and/or get it into an
endless loop (or very long loops like multiminute parsing etc).

I plan to use those as case studies for my systematic troubleshooting presentation at Hotsos Symposium this year (preferably versions 10.2 and 11g), so any examples on how to create weird (performance) problems in Oracle are welcome!

Please send me the answer in private in order to not flood Oracle-L with junk ;)
I'll blog the most interesting ones later on and give credits accordingly.



Tanel Poder


-- Received on Tue Feb 12 2008 - 08:29:15 CST

Original text of this message