Re: troubleshooting hangs & endless loops in Oracle

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.

--romas

On 2/12/08, Tanel Poder <tanel.poder.003_at_mail.ee> wrote:
>
> 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