RE: troubleshooting hangs & endless loops in Oracle
Date: Tue, 12 Feb 2008 09:29:15 -0500
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.
[mailto:oracle-l-bounce_at_freelists.org] 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
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
I'll blog the most interesting ones later on and give credits accordingly.
http://www.freelists.org/webpage/oracle-l Received on Tue Feb 12 2008 - 08:29:15 CST