Delete uncommitted oracle transactions

First query the uncommitted transactions SELECTdob. OBJECT_NAMETable_Name, lo. SESSION_ID |, | vss. SERIAL # delete number, lo. locked_mode, lo. SESSION_ID, vss. SERIAL #, vss. actionAction, vss. osuserOSUSER, vss. LOGON_TIME, vss. processAP_PID, VPS. SPIDDB_PID, vss. * From

First query the uncommitted transaction SELECT dob. OBJECT_NAME Table_Name, lo. SESSION_ID | ',' | vss. SERIAL # delete number, lo. locked_mode, lo. SESSION_ID, vss. SERIAL #, vss. action Action, vss. osuser OSUSER, vss. LOGON_TIME, vss. process AP_PID, VPS. SPID DB_PID, vss. * From

First query uncommitted transactions

SELECT dob. OBJECT_NAME Table_Name, lo. SESSION_ID | ',' | vss. SERIAL # delete number,

Lo. locked_mode, lo. SESSION_ID, vss. SERIAL #, vss. action Action, vss. osuser OSUSER, vss. LOGON_TIME,

Vss. process AP_PID, VPS. SPID DB_PID, vss .*

From v $ locked_object lo, dba_objects dob, v $ session vss, V $ PROCESS VPS

Where lo. OBJECT_ID = dob. OBJECT_ID

And lo. SESSION_ID = vss. SID

And vss. paddr = VPS. addr

Order by 2, 3, DOB. object_name

Delete the queried transaction ('1717' is the deletion number queried above)

ALTER system kill session '2017 17'