Re: Web and Lock...

Comments embedded

On 19 Nov 2003 06:39:38 -0800, srinivasanvijay_2000_at_yahoo.com (Vijays) wrote:

>Hi
>
>I have seen many posting related to Lock / Kill / Acquire / Release
>... In our web scenario , we have built a SOFT LOCK approach, where we
>store the PK's with session id Etc Etc of the row that has been
>retrieved and put a timeout seconds...
>
>We have been trying to convert out existing forms 6i app to web ..
>most of the places we have a execute query with update clause..means,
>when i retrieve the row, it acquires the lock !!!
There is no need for that. Forms will automagically issue a select for update when the end-user changes a record. So your approach is just asking for trouble.

The problem is
>connection drops !!!

Which probably means you also have a lousy network.

I am sure PMON wakes up time to time to clean up
>these dead processes...but what is that interval time ???
20 or 30 seconds, IIRC

How long ???
>Can we set the interval in which PMON is expected to wake up and clean
>???

Guess! It is NOT configurable.

If i get the answers for these, probably i would look at existing
>method...Otherwise, i got to implement the soft lock approach as i
>mentioned above in all the forms...(any better idea)..

Why on earth do you need to implement this method? Is there any reason you can't live with the standard Oracle locking?

>
>Also, if somebody can give me an input of what are the parameters that
>i have to setup in forms90.properties to make it run fastly and
>efficiently...is there is something can be done at Jinitator level to
>make it better !!! any help is highly appreciated..
>

The parameter is probably called 'consultant', as crystall balls have sold out here, and your question goes beyond anything a voluntary group would answer.

>vj

--
Sybrand Bakker, Senior Oracle DBA