SELECT SID,SERIAL#,USERNAME,STATUS,SERVER,SCHEMANAME,OSUSER,MACHINE,PROGRAM FROM V$SESSION WHERE SID IN (SELECT SID FROM V$LOCK)
ALTER SYSTEM KILL SESSION 'SID,SERIAL#'
【参考】
SELECT TABLE_NAME, COLUMN_NAME, SUBSTR(COMMENTS, 0, 10), OWNER FROM ALL_COL_COMMENTS WHERE TABLE_NAME = 'テーブル名' AND OWNER='所有者名';
SELECT VALUE FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER='NLS_CHARACTERSET'