![oracle kill session by sid oracle kill session by sid](https://slideplayer.com/slide/13087854/79/images/58/Managing+an+Oracle+Instance.jpg)
We might be doing on demand recovery of the blocks which makes it "appear" faster but we still have to recover the transaction.
![oracle kill session by sid oracle kill session by sid](https://4.bp.blogspot.com/-JblIVr7QM_I/W5VQzkQMtzI/AAAAAAAABO4/RdDUjxgWGfcumSSXEBSlm5kgeLYOC7qMwCLcBGAs/w1200-h630-p-k-no-nu/Screen%2BShot%2B2018-09-09%2Bat%2B11.56.22%2BPM.png)
If you kill -9, it might appear that the session is gone "faster" but not really. Now we are done rolling back select username, status from v$session where username = 'BIG_TABLE' Session is still select used_ublk from v$transaction We can watch the used_ublk shrink and even use that to estimate when it'll be /ġ row select username, status from v$session where username = 'BIG_TABLE' ORA-00031: session marked for select username, status from v$session where username = 'BIG_TABLE' ġ row select used_ublk from v$transaction That means the server heard us and is in the process of rolling back but it'll take a alter system kill session '8,1082' I kill it and get the message "it is marked for kill". It generated that much undo so SID_SERIAL STATUS MODULE ACTIONīIG_TABLE(8,1082) ospid = 13903 command = 7 program = (TNS V1-V3) dedicated server=13904 This is what you'll see (you need to be more selective on the query against v$transaction of course, I just had one active DML session select used_ublk from v$transaction
![oracle kill session by sid oracle kill session by sid](https://image1.slideserve.com/1810235/terminating-sessions-l.jpg)
In a schema "big_table" i started a delete against a 1,000,000 row indexed table. You can monitor how the killed session is doing as far as rolling back is concerned in v$transaction via the used_ublk column.Ĭonsider this example. If the job took an hour to get where it is, it might take even LONGER to "undo" what its done. The job isn't "going on" it is actually "going back" - it is rolling back.