Is your application running through
Oracle's web-server ? If so, that is
probably the answer. After every
call you (used to) get a 'reset_all_packages'
call and a rollback;
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
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
Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.
Prince Kumar wrote in message
<629275ba.0109051138.f731258_at_posting.google.com>...
>While reading the statspack report I noticed a very high percentage of
>rollback.
>
>Is there any way to find who/what is causing all these rollbacks. If
>"logminer" is the only solution, which table.column of v$logminer...
>view tells me whether the operation was "rollback"?
>
>
>thanks,
Received on Wed Sep 05 2001 - 14:48:18 CDT
