Re: Oracle Lock problem ! i really need help !

Jim Smith wrote:
>
> You should index your foreign key. This is a feature of Oracle where it
> takes a table lock in certain circumstances if foreign columns are not
> indxed.
> --
> Jim Smith

We are using Oracle 7.1.3.* and are concidering to skip 7.2 to 7.3. This locking behaviour is currently pain in the neck. Doesn't help much yet to see how nicely it changes, if you look at Oracle7 Server Application Developer's Guide (Dec. 1992): chapter 6 figure 6-4, and then compare the picture with a newer version.

It changes in 7.2 (or was it even 7.1.6.something)

-- 
----------------------------------------------------------------------
Lassi Salo, System Specialist, NTC International Logistics  
Nokia Telecommunications, P.O.Box 33, FIN-02601 Espoo, FINLAND  
Mail: lassi.salo_at_ntc.nokia.com  Phone: +358-0-5112 2725  
Fax: +358-0-5112 2227  Nokia's Home: http://www.nokia.com/  
----------------------------------------------------------------------