SYS@ecard> select username,sid,serial# from v$session where username=upper(‘CCENSE’);
USERNAME SID SERIAL#
CCENSE 23 139
SYS@ecard> alter system kill session ‘23,139’;
System altered.
SYS@ecard> drop user ccense cascade;
User dropped.
SYS@ecard> select username,sid,serial# from v$session where username=upper(‘CCENSE’);
USERNAME SID SERIAL#
CCENSE 23 139
SYS@ecard> alter system kill session ‘23,139’;
System altered.
SYS@ecard> drop user ccense cascade;
User dropped.