_____________________________________________________________________________________

Managing Processes:
https://docs.oracle.com/cd/E11882_01/server.112/e25494/manproc.htm#ADMIN11000
_____________________________________________________________________________________

set pages 1000
set lines 200
_____________________________________________________________________________________

ALTER SESSION:
https://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_2013.htm#SQLRF00901

alter session set current_schema=SCOTT;
alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';
_____________________________________________________________________________________

GENERAL INFO (V$SESSION)
========================
https://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_3016.htm#REFRN30223

column USERNAME format a20
column OSUSER   format a15
column PROGRAM  format a30
  
select username, osuser, program, to_char(logon_time,'yyyy-mon-dd hh24:mi:ss') "LOGON_TIME"
from v$session
where osuser <> 'oracle'
order by 4 desc;

select username, osuser, program, sid, serial#
from v$session
where username <> ' ';

select username, to_char(logon_time,'YYYY-MM-DD_HH24:MI:SS'), osuser, program, sid, serial#
from v$session
where username <> ' ';

select username, sid, serial#
from v$session
where username <> ' ';

select username, osuser, program
from v$session
where username <> ' ';

select 'alter system kill session ''' || sid || ',' || serial# || ''';'
from v$session where username = upper('XXXNAMEXXX');

select 'alter system kill session ''' || sid || ',' || serial# || ''';'
from v$session where sid = XXXSIDXXX;



RESTRICTED SESSION
==================
select logins from v$instance;

alter system disable restricted session;



BLOCKING SESSIONS
=================
select username, to_char(logon_time,'YYYY-MM-DD_HH24:MI:SS'), osuser, program, sid, serial#
from v$session
where sid in
  (select blocking_session
   from v$session
   where blocking_session is not null);

set feedback off
set heading  off
select 'ALTER SYSTEM KILL SESSION ''' || sid || ',' || serial# || ''' IMMEDIATE;' "KILL-STATEMENT"
from v$session
where sid in
  (select blocking_session
   from v$session
   where blocking_session is not null);

_____________________________________________________________________________________