Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: understanding rollback segments
Dave,
I think that the rollback maintains the consistency of the cursor so that your cursor select statement "sees" the database as it existed at the moment you opened the cursor. Since your cursor will not be closed until the end of your loop this keeps the rollback active and things tend to grow too large. I've never tried to figure out what exactly is going on, I just know that an open cursor has an equivilent effect as no commit.
_/ _/ _/_/_/_/ _/_/_/_/ Schlumberger, Meter Communication Systems
_/_/ _/_/ _/ _/ Ed Poorbaugh _/ _/ _/ _/ _/_/_/_/ 3155-B Northwoods Parkway _/ _/ _/ _/ Norcross, GA 30071 _/ _/ _/_/_/_/ _/_/_/_/ 770 368-3444 ext. 3121, 840-8614 (fax) poorbaugh_at_norcross.mcs.slb.comReceived on Wed Apr 23 1997 - 00:00:00 CDT