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

Home -> Community -> Mailing Lists -> Oracle-L -> non-rollback-able DML

non-rollback-able DML

From: andrey <bronfin_at_visualtop.com>
Date: Tue, 5 Dec 2000 13:33:28 +0200
Message-Id: <10701.123632@fatcity.com>


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>&nbsp;</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&nbsp;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>&nbsp;</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>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D563212611-05122000></SPAN></FONT>&nbsp;</DIV></BODY></HTML> Received on Tue Dec 05 2000 - 05:33:28 CST

Original text of this message

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