I have a table that is locked. A procedure was running on this table when I killed the session. I have waited about a half hour and the table is still locked. Is there anyway I can unlock the table?
Printable View
I have a table that is locked. A procedure was running on this table when I killed the session. I have waited about a half hour and the table is still locked. Is there anyway I can unlock the table?
is the session dead? if not, it is rolling back tx.
The procedure inserted records into a table and committed after every one. So even if it rolled back it would have been for only one record. Everytime I do a alter session kill it says that it is marked for kill but it isn't killed.
check dba_blockers for blocking sessions
GCPRPRD>select * from dba_blockers;
no rows selected
Is this a production database or develop or testing database?
When I have this problem in testing, the fast way is to shutdown abort. No one cares about data any way.