select V$SESSION.SID, USERNAME, STATUS, PROGRAM, LOCKWAIT, SQL_TEXT, 'alter system kill session ''' || V$SESSION.SID || ',' || serial# || '''' from V$SESSION,V$OPEN_CURSOR where SQL_ADDRESS = ADDRESS and USERNAME is not NULL