Unlock a table

[lesstjm]

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?

[ocpwannabe]

is the session dead? if not, it is rolling back tx.

[lesstjm]

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.

[ocpwannabe]

check dba_blockers for blocking sessions

[lesstjm]

GCPRPRD>select * from dba_blockers;

no rows selected

[xyz2000]

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.