RE: troubleshooting hangs & endless loops in Oracle

  • From: <Joel.Patterson@xxxxxxxxxxx>
  • To: <tanel.poder.003@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 12 Feb 2008 09:29:15 -0500

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@xxxxxxxxxxx
x72546
904  727-2546

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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

--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l


Other related posts: