SELECT SID, SERIAL# FROM V$SESSION WHERE SID IN ( SELECT SID FROM V$LOCK WHERE TYPE IN ('TM','TX') );
SID SERIAL#
---------- ----------
70 1604
197 868
alter system kill session 'SID, SERIAL#'
SELECT SID, SERIAL# FROM V$SESSION WHERE SID IN ( SELECT SID FROM V$LOCK WHERE TYPE IN ('TM','TX') );
sqlplus [username]/[passowrd]@[IP Addr]:[Port Number]/[Service Name]
DROP USER username CASCADE; -- drop user and user schema.
DROP USER username ; -- drop user only.