RE: Table Lock

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

<SPAN
class=383142612-13022002> 
<SPAN
class=383142612-13022002>   

Hussain Ahmed Qadri
Database Administrator
Shaukat Khanum Memorial Cancer Hospital & Research Centre
hussain_at_skm.org.pk
www.shaukatkhanum.org.pk<FONT
size=1>Hussain Ahmed Qadri
Database Administrator
Shaukat Khanum Memorial Cancer Hospital & Research Centre
hussain_at_skm.org.pk
<FONT
face=Arial>www.shaukatkhanum.org.pk

<FONT face=Tahoma

  size=2>-----Original Message-----From: Arvind Kumar   [mailto:arvindk_at_sqlstarintl.com]Sent: Wednesday, February 13, 2002   3:29 PMTo: Multiple recipients of list ORACLE-LSubject:   Table Lock
<SPAN

  class=296312910-13022002>Hi,
<SPAN

  class=296312910-13022002> 
<SPAN

  class=296312910-13022002>  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 ,
<SPAN

  class=296312910-13022002> 
<SPAN

  class=296312910-13022002> 
<SPAN

  class=296312910-13022002>Regards
<SPAN

  class=296312910-13022002>Arvind Received on Wed Feb 13 2002 - 08:54:37 CST