troubleshooting hangs & endless loops in Oracle

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Tue, 12 Feb 2008 21:59:25 +0800
Message-id: <04da01c86d7f$800da070$3201a8c0@windows01>

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 Received on Tue Feb 12 2008 - 07:59:25 CST

This message: [ Message body ]
Next message: Peter Teoh: "Re: Large table query with cpu throttling"
Previous message: Finn Jorgensen: "Re: Db file scattered reads vs. direct path reads"
Next in thread: Roman Podshivalov: "Re: troubleshooting hangs & endless loops in Oracle"
Maybe reply: Brian MacLean: "Re: troubleshooting hangs & endless loops in Oracle"
Reply: Roman Podshivalov: "Re: troubleshooting hangs & endless loops in Oracle"
Reply: Joel.Patterson_at_crowley.com: "RE: troubleshooting hangs & endless loops in Oracle"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message