Search This Blog

Total Pageviews

Thursday, 13 October 2011

Oracle Active session and session kill

logged on session
current session
current user
session kill



SET linesize 200 PAGESIZE 1000 FEED OFF;
COLUMN "sid,serial#" FORMAT A12
COLUMN "pid" FORMAT 999
COLUMN "status" FORMAT A8
COLUMN "schema" FORMAT A10
COLUMN "osuser" FORMAT A10
COLUMN "box" FORMAT A16
COLUMN "prg" FORMAT A30
--
SELECT
''''
|| s.sid
|| ','
|| s.serial#
|| ''';' "sid,serial#"
, p.spid "pid"
, s.status "status"
, s.schemaname "schema"
, s.osuser "osuser"
, s.machine "box"
, s.program "prg"
, TO_CHAR(s.logon_time, 'DD.MM.YYYY HH24:MI') "logon_time"
,sql_id
,PREV_SQL_ID
FROM
v$session s,
v$process p
WHERE s.paddr = p.addr
and s.serial#>10
ORDER BY s.username
/



prompt alter system kill session 'sid,serial#' IMMEDIATE;

prompt alter system kill session 'sid,serial#,@1'; RAC

No comments:

Oracle DBA

anuj blog Archive