Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: undo retention

Re: undo retention

From: Keith <keithhoxie_at_verizon.net>
Date: 14 Feb 2006 20:14:28 -0800
Message-ID: <1139976868.145625.234780@g14g2000cwa.googlegroups.com> 





The general rule seems to be that committing (potentially) invalidates
any open cursor (because oracle incorrectly marks rollback information
as no longer needed) it is often possible to get away with it though if
the information is being used by the cursor, is not modified while the
loop is running, The point being that the periodic commit structure may
work on development or test only to fail on the production server.
Received on Tue Feb 14 2006 - 22:14:28 CST












Original text of this message













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