Re: Oracle locking up..?

rodi_at_bbs.no (Noddy) wrote in message news:<a62a27da.0402130554.22956637_at_posting.google.com>...
> We have an application that updates a row in a table. Sometimes Oracle
> does not respond for over 10 seconds. This is after an insert. It
> seems that there is a lock somewhere. This is a multi user system.
> Records can be added 3+ pr. second.
>
> We have a procedure stored that does the actuall insert. Documented
> below. As you can see the insert is pretty straight forward. (look at
> the last section in the procedure).
>
> What can cause this situation in Oracle;
>
> * Table lock... ? How does Oracle lock tables when updating.

There is a document in your doc set or you can find at tahiti.oracle.com called the Applications Developers Guide Fundamentals. Free registration required at otn.oracle.com.  

http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adg08sql.htm#2477

This is a decremented group, see
http://members.cox.net/oracleunix/readme-cdos.htm

jg

--
_at_home.com is bogus.
http://www.firstgov.gov/fgsearch/resultstrack.jsp?sid=114501421&url=http://www.uspto.gov/web/offices/pac/dapp/opla/comments/searchbmp/everhart.pdf