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 -> Re: select for update on 7.3.2

Re: select for update on 7.3.2

From: netac <netac_at_worldnet.att.net>
Date: 1997/03/24
Message-ID: <3336C534.6094@worldnet.att.net>#1/1

Foo Jee Ming wrote:
>
> James Powrie (jp_at_manip.demon.co.uk) wrote:
> >: Has anyone experienced a problem with 'select for update' queries on
> >: 7.3.2. We are
> >: considering upgrading from 7.2.3 to 7.3.2 and our acceptance testing has
> >: revealed
> >: a problem which hangs the unix process associated with the session that
> >: performs
> >: the select ..... for update query. Although I have experienced the
> >: problem on two seperate instances, I don't yet have a definitive recipe
> >: for ORACLE to reproduce the problem.
 

> >: I am currently jousting with ORACLE 1st level support trying to resolve
> >: this problem. ORACLE support's position is that 7.3.2 is innocent until
> >: proven guilty, and the onus is on me to either resolve the problem
> >: myself or to provide ORACLE with a definitive way to reproduce the
> >: problem. While I fully appreciate their position, my position is that I
> >: don't have the time nor the inclination to isolate and diagnose what I
> >: believe to be server problems (we have already had one patch).
 

> >: This is why I am desperately hoping that somebody else has experienced
> >: this problem. This would shift the burden of proof and allow me to get
> >: on with the rest of my duties.
>
> Hi,
>
> Nice to know that someone is facing the same problem as us. :)
> We have an SQL statement 'Select ... order by ... for update nowait'
> which seems to 'hang' sometimes.
>
> We have tested a couple of variations of the above SQL, and so far it
> appears that the 'for update' clause is kinda flaky. I have opened a
> TAR with Oracle support here, but there's no news from them yet.
>
> To summarize: Yes, there are people facing the same problem as you.
> The Oracle tech support people here recommend
> us to migrate to 7.3.2.3 as well. :)
>
> rgds
>
> >: James.
>
> ---
> #include <std_disclaimer.h>
> Foo Jee Ming
> Kuala Lumpur, MALAYSIA

In 7.3.2.1 (Solaris), select for updates would corrupt data read from tables which contained LONG fields (the data in the LONG was corrupted). We are waiting for 7.3.3 Received on Mon Mar 24 1997 - 00:00:00 CST

Original text of this message

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