Database Administration (MOSC)

MOSC Banner

KILLED session remains for 6 hours in v$session.

edited May 10, 2018 12:03PM in Database Administration (MOSC) 7 commentsAnswered ✓

I have killed session worked for 5 minutes.

Waited for 1 hour, but session remained in KILLED.

Then killed corresponding OS process.

select spid from v$session s, v$process p where s.PADDR=p.ADDR and s.SID=1515

SPID

--------

3657

But after 6 hours session still remains in v$session and holding locks and opened transactions. How it is correct to ger rid of this session ?

SELECT s.username,

       s.SID,

       s.serial#,

       s.logon_time,

       t.xidusn,

       t.ubafil,

       t.ubablk,

       t.used_ublk,

       t.start_time AS txn_start_time,

       t.status,

       ROUND (t.used_ublk * TO_NUMBER (x.VALUE) / 1024 / 1024, 2) || ' Mb'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center