Run this first if you're getting ORA-1000: Maximum open cursors exceeded errors.
--who has how many cursors open?
select a.osuser, a.sid,a.username, a.machine, count(*) from
v$session a, V$OPEN_CURSOR b
where a.sid = b.sid
group by
a.osuser, a.sid, a.username,a.machine
order by count(*) desc;
Note: Proofread any scripts before using. Always try scripts on a test
instance
first. I'm not responsible for any damage, even if you somehow manage to make my
scripts corrupt every last byte of your data, set your server on fire and serve you
personally with an eviction notice from your landlord!
All scripts and tips © Natalka Roshak 2001-2005.
Enjoy the FREE tips folks...