Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> non-rollback-able DML
This is a multi-part message in MIME format.
------=_NextPart_000_000F_01C05EBF.F35348E0 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Dear all !
Is there a way to perform a DML ( insert , update , delete ) against an
Oracle DB without writing to rollback segments ( in order to improve
performance ) ?
Is there a way to insert , update , delete without writing to redo log
buffer as well ( i'm aware of "nologging" , but this does not good enougth
for any DML ) .
TIA .
Andrey .
------=_NextPart_000_000F_01C05EBF.F35348E0 Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D563212611-05122000>Dear =
all=20
!</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D563212611-05122000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D563212611-05122000>Is =
there a way to=20
perform a DML ( insert , update , delete ) against an Oracle DB without =
writing=20
to rollback segments ( in order to improve performance ) =
?</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D563212611-05122000>Is =
there a way to=20
insert , update , delete without writing to redo log buffer as well =
( i'm=20
aware of "nologging" , but this does not good enougth for any DML )=20
.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D563212611-05122000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D563212611-05122000>TIA=20
.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D563212611-05122000>Andrey =
.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D563212611-05122000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D563212611-05122000></SPAN></FONT> </DIV></BODY></HTML>
Received on Tue Dec 05 2000 - 05:33:28 CST