Re: troubleshooting hangs & endless loops in Oracle
Date: Tue, 12 Feb 2008 10:16:57 -0500
I'm not sure about multiminute parsing but for inter process communication, parallel execution, sorts and CPU hog I use very simple statement:
select /*+ PARALLEL (a, 5) PARALLEL (b, 10) PARALLEL (c, 15) */ * from all_objects a, all_objects b, all_objects c order by 1,2,3,4,5,6;
Just make sure your temp space is adequate because it will be funny if during the live demo you will get out of temp error ;-) This statement should last for about 3-5 minutes depending on your CPU speed. If you need more you can scale it very easily.
On 2/12/08, Tanel Poder <tanel.poder.003_at_mail.ee> wrote:
> 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