RE: Oracle FM interpretation of locking behavior

Yes, it does answer my question. And it should have been easy enough for me to test if I had been *thinking*.

I'll blame it on me being sick yesterday and still not in the right frame of mind, and my ribs are still tender from repeated reverse peristalsis.

Thanks, Robert! :)

Rich

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Robert Pegram [mailto:pegramrg_at_yahoo.com]
> Sent: Tuesday, December 10, 2002 12:36 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Oracle FM interpretation of locking behavior
>
>
> If I understand what you are asking, a simple test
> will tell you.
>
> >>> Session A
>
> SQL> create table t2 (x number);
>
> Table created.
>
>
> SQL> insert into t2 values (1);
>
> 1 row created.
>
> SQL> insert into t2 values (2);
>
> 1 row created.
>
> SQL> commit;
>
> Commit complete.
>
> SQL> update t2 set x=4 where x=1;
>
> 1 row updated.
>
> SQL>
>
> Notice No commit;
>
> >>>>>>> Session B
> SQL> update t2 set x=4 where x=2;
>
> 1 row updated.
>
> SQL> update t2 set x=4 where x=1;
>
> >>> this waits for the commit/rollback in session A
>
> Robert Pegram
> Oracle Certified DBA (8i,9i)
>
>
> --- "Jesse, Rich" <Rich.Jesse_at_qtiworld.com> wrote:
> > Hey all,
> >
> > After converting three columns on a multi-million
> > row table from NULLs to
> > SPACEs, the devs found one other program that pops
> > NULLs into those columns
> > (sigh). So, with only 150 rows needing updating, my
> > knee-jerk reaction was
> > to do a simple:
> >
> > UPDATE mytable
> > SET mcol1 = ' '
> > WHERE mcol1 IS NULL;
> >
> > ...and repeat for "mcol2" and "mcol3". Since this
> > is a heavy table for us
> > (Time/Attendance), I'm wondering about locking,
> > since the UPDATEs won't be
> > using an index because of the "IS NULL". When I
> > RTFM for 8.1.7, I found
> > this:
> >

...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).