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: COMMIT in for loop

Re: COMMIT in for loop

From: Kenneth C Stahl <kstahl_at_lucent.com>
Date: Mon, 21 Jun 1999 11:28:50 -0400
Message-ID: <376E5A32.24CB34C2@lucent.com> 







amyleone_at_my-deja.com wrote:



> > 1. Make sure that you have a rollback segment that has an OPTIMAL size


> > set


>


> How can I determine this?





Use storage manager and look at the rollback segments. Alternatively, select
* from dba_rollback_segs;


Received on Mon Jun 21 1999 - 10:28:50 CDT












Original text of this message













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