select s.sid, s.serial#, s.status, p.spid from v$session s, v$process p

where s.username = '' and p.addr (+) = s.paddr

/

select job from dba_jobs where log_user='';

select queue_table,qid from dba_queues where wner='myuser';

select apply_name from dba_apply where queue_owner='myuser';

select capture_name, queue_name, from dba_capture where queue_owner='myuser';

select propagation_name from dba_propagation where

source_queue_owner='myuser'

or destination_queue_owner='myuser';

Kill the session that has not been already kill with:

alter system kill session ',';

If all the session are noted 'KILLED' then kill the Unix process (column

spid) with "kill -9".

Then after a while the session will be removed from v$session and you will

be able to drop the user.

ITPub博客

ORA-01940: cannot drop a user that is currently connected