DROP USER CASCADE is taking forever!! Can't see any blocks...ideas?
cayenneMay 26 2010 — edited May 27 2010Hello all,
I'm running a script that has a drop user cascade, and it has been sitting there for about 3.5 hours at this point.
I ran a query to see if I could find any blocking sessions:
SQL> edit
Wrote file afiedt.buf
1 SELECT DECODE(request,0,'Holder: ','Waiter: ')||sid sess,
2 id1, id2, lmode, request, type
3 FROM V$LOCK
4 WHERE (id1, id2, type) IN
5 (SELECT id1, id2, type FROM V$LOCK WHERE request>0)
6* ORDER BY id1, request
SQL> /
no rows selected
So, I'm kinda stuck...is there a way to see what maybe is holding this up? This is being run on a 3x node RAC system...I'd think this would go pretty quickly...
any ideas on what to do or what to look at?
TIA,
cayenne