Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to release lock on table

892574May 31 2013 — edited May 31 2013
Hi,

i ran 2 insert statements and i have killed those statements.

because of that row exclusive lock has been occured on two tables.

can we release lock on those tables or we need to wait?

53 sysadm TM - DML Enq HC_MP_TBL sysadm 299698811 0 Row Excl
PSAESRV@server.c 52680
orio.com (TNS V1-V
3)

532 sysadm TM - DML Enq HC_TC_RT_TBL sysadm 299696570 0 Row Excl
PSAESRV@server.c 50207
orio.com (TNS V1-V

Edited by: 889571 on May 31, 2013 9:55 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 28 2013
Added on May 31 2013
#11g, #general-database-discussions
2 comments
655 views