Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Deferrable FKs, any locking issues?

Deferrable FKs, any locking issues?

From: <n.a.ekern_at_usit.uio.no>
Date: 30 Oct 2001 13:05:33 GMT
Message-ID: <9rm8it$95t$1@readme.uio.no> 





We are planning on recreating our foreign keys from being 'not deferrable' 
to be 'defearrable initially immediate'.



But, we have many foreign keys (more than 500 tables, more than 1000 fk's) 
and ca 100 simultanously logged in users, so we are concerned whether this 
can cause increased locking-activity in the database, and then 
session-hangs for the users.



Anybody know if it is unwise to declare fk's as 'deferrable initially 
immediate'?



Tia,


Njål A. Ekern
Received on Tue Oct 30 2001 - 07:05:33 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US