RE: select for update

I was hoping you could use profiles to set a resource limit, but after researching I see you don't have a resource limit dealing with locks. Maybe you could look at resource limits and find a different solution.

Michael Armstead

> -----Original Message-----
> From: guy ruth hammond [SMTP:grh_at_agency.com]
> Sent: Tuesday, July 18, 2000 4:49 PM
> To: Multiple recipients of list ORACLE-L
> Subject: select for update
>
> Hi all,
>
> I've got a bit of a weird problem. I have a bunch of user connecting to
> Oracle 8.1.6 via a middleware layer, which provides a connection pool.
> The code they are running contains lots of SELECT FOR UPDATE statements,
> because we need to ensure that things happen in sequence, rather than
> a situation in which process 1 can issue an UPDATE, process 2 issue a
> plain SELECT, then process 1 COMMIT.
>
> The processes connect to middleware, then middleware connects to Oracle,
> so if a process dies (which happens from time to time), Oracle doesn't
> know. If a process requests a lock, then dies, Oracle will hold that
> lock, and all the other processes will be stalled. We know that if
> a process is successful, it will never require a lock for longer than
> 2 seconds, but we allow 10 seconds.
>
> So my problem is, is there a way to tell Oracle to automatically
> free any locks once they reach a certain age?
>
> Thanks,
>
> g
>
>
> --
> guy ruth hammond <grh_at_agency.com> | One is punished for being
> Technology Analysis & Consulting | weak, not for being cruel.
> 617 4521300 http://www.agency.com | -- Baudelaire
> --
> Author: guy ruth hammond
> INET: grh_at_agency.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Jul 19 2000 - 08:08:51 CDT