Sessions

ALTER SYSTEM KILL SESSION 'a, b';

-- a - sid, b - serial#

select SID, USERNAME, STATE, SECONDS_IN_WAIT, COMMAND from V$SESSION;

select SID, USERNAME, STATE, SECONDS_IN_WAIT, COMMAND from V$SESSION where USERNAME='SYS';

SELECT V$SQL.SQL_ID, V$SESSION.SQL_ID, V$SESSION.STATUS, V$SQL.SQL_TEXT, V$SQL.EXECUTIONS, V$SQL.CHILD_ADDRESS, V$SQL.ROWS_PROCESSED, V$SQL.BUFFER_GETS, V$SQL.MODULE, V$SQL.LOADS, V$SQL.FIRST_LOAD_TIME, V$SQL.LAST_ACTIVE_TIME, V$SESSION.SID, V$SESSION.SADDR, V$SESSION.SQL_CHILD_NUMBER, V$SESSION.PREV_SQL_ADDR, V$SESSION.LOGON_TIME, V$SESSION.USER#, V$SESSION.PROCESS, V$SESSION.PROGRAM, V$SESSION.BLOCKING_SESSION_STATUS, V$SESSION.EVENT FROM V$SQL, V$SESSION WHERE V$SQL.SQL_ID = V$SESSION.SQL_ID;

select rownum rnum,sid,serial#,status,username,last_call_et,command,machine,osuser,module,action,resource_consumer_group,client_info,client_identifier,type,terminal from v$session;

select rownum rnum,sid,serial#,status,username,command,machine,action,client_info,client_identifier from v$session;