RE: Table Lock

[Hussain Ahmed Qadri]

Try creating indexes on the foreign key columns, in the child tables.

 

 

Hussain Ahmed Qadri

Database Administrator

Shaukat Khanum Memorial Cancer Hospital & Research Centre

[EMAIL PROTECTED]

www.shaukatkhanum.org.pkHussain Ahmed Qadri

Database Administrator

Shaukat Khanum Memorial Cancer Hospital & Research Centre

[EMAIL PROTECTED]

www.shaukatkhanum.org.pk

-----Original Message-----
From: Arvind Kumar [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 13, 2002 3:29 PM
To: Multiple recipients of list ORACLE-L
Subject: Table Lock

Hi,

 

  i am running Oracle 8.1.6 on RedHat 6.1 , the problem is one of my Table is getting locked and not getting unlocked until i kill the session. the users r reporting that they r not using anything which may lock this table ,

 

 

Regards

Arvind