Are you aware that any SQL statement that
executes inside a PL/SQL block is counted
as a recursive SQL statement ?
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
anil chada wrote in message
<36503db6.0204031125.769d8588_at_posting.google.com>...
>if oracle is spending most of the time parsing recursive calls, then
>can anyone provide me with some ideas about,
>how to isolate the problem and fix it (apart from increasing share
>pool size)?
>
>
>Any input is greatly appreciated.
>
>Thanks
>Anil
Received on Sat Apr 06 2002 - 08:37:30 CST
