Does the process show up in V$session. (Most people have scripts joining v$session and v$process to show sessions that will not show sessions because the show will only show sessions with process and you can miss some in other states.) Sometime app/web servers constantly relog in after being killed making it hard to drop the user. In those cases I shutdown /startup restrict, drop the user then take off the restricted session. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of John Dunn Sent: Wednesday, July 05, 2006 5:27 AM To: 'oracle-l digest users' Subject: ORA-01940: cannot drop a user that is currently connected ORA-01940: cannot drop a user that is currently connected I get this error on Oracle 10.2.0.1.0 but cannot see any sessions for the user. I have rerun the drop, but now it just hangs. Anything I can do but bounce the database? John Dunn Product Consultant Direct Dial +44 (0) 117 373 6122 Sefas Innovation Ltd, CityPoint, Temple Gate, Bristol BS1 6PL, UK. Tel: +44(0) 117 373 6114 Fax: +44 (0) 117 373 6115 www.sefas.com