–oracle kill session
select sql_text from v
s
q
l
t
e
x
t
a
w
h
e
r
e
(
a
.
h
a
s
h
v
a
l
u
e
,
a
.
a
d
d
r
e
s
s
)
i
n
(
s
e
l
e
c
t
d
e
c
o
d
e
(
s
q
l
h
a
s
h
v
a
l
u
e
,
0
,
p
r
e
v
h
a
s
h
v
a
l
u
e
,
s
q
l
h
a
s
h
v
a
l
u
e
)
,
d
e
c
o
d
e
(
s
q
l
h
a
s
h
v
a
l
u
e
,
0
,
p
r
e
v
s
q
l
a
d
d
r
,
s
q
l
a
d
d
r
e
s
s
)
f
r
o
m
v
sqltext a where (a.hash_value,a.address) in (select decode(sql_hash_value,0,prev_hash_value,sql_hash_value),decode(sql_hash_value,0,prev_sql_addr,sql_address) from v
sqltextawhere(a.hashvalue,a.address)in(selectdecode(sqlhashvalue,0,prevhashvalue,sqlhashvalue),decode(sqlhashvalue,0,prevsqladdr,sqladdress)fromvsession b where b.paddr = (select addr from v$process c where c.spid = ‘&PID’)) order by piece ASC;
select sid,serial#,username,osuser,machine,program,process,to_char(logon_time,‘yyyy-mm-dd hh24:mi:ss’) logon from v s e s s i o n w h e r e p a d d r i n ( s e l e c t a d d r f r o m v session where paddr in ( select addr from v sessionwherepaddrin(selectaddrfromvprocess where spid in (’&PID’));
select sid,serial#,status from v
s
e
s
s
i
o
n
w
h
e
r
e
p
a
d
d
r
i
n
(
s
e
l
e
c
t
a
d
d
r
f
r
o
m
v
session where paddr in ( select addr from v
sessionwherepaddrin(selectaddrfromvprocess where spid in (’&PID’));
alter system kill session ‘745,36427’