HI Daniel,
thanks. Could you be a bit more specific about the cursor loop? I've
used a cursor loop often to do batch updates during busy trading
hours, so that I keep locking at minimum level and not interrupt
trading applications. I don't necessarily consider that as a bad use,
since a single long update would collide with lots of sessions and
cause deadlocks. Is that the kind of usage you do not like? If not,
what bad experiences have you had with it, how would you rate the
problem (performance?).
--
gojko adzic
http://gojko.net
> My contributions to start it off:
> 1. Following advice from certain authors ... provide a list.
> 2. Anything that references BCHR and doesn't include the word "myth."
> 3. Anything that involves the phrase "index" and "rebuild" in the
> same sentence but does not include a reference to it being rarely
> required.
> 4. Anything that uses a cursor loop.
> 5. EXECUTE IMMEDIATE 'COMMIT'; ... and yes I've seen it in production
> code.
> --
> Daniel A. Morgan
> Oracle Ace Director & Instructor
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
Received on Thu Dec 20 2007 - 12:54:13 CST
