RE: troubleshooting hangs & endless loops in Oracle
Date: Tue, 12 Feb 2008 09:29:15 -0500
Message-ID: <0684DA55864E404F8AD2E2EBDFD557DAAF9899@JAXMSG01.crowley.com>
P.S.
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
joel.patterson_at_crowley.com
x72546
904 727-2546
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[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
Hi,
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.
Thanks!
--
Regards,
Tanel Poder
http://blog.tanelpoder.com
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 12 2008 - 08:29:15 CST