RE: non-rollback-able DML

From: Gary Weber <gweber_at_cji.com>
Date: Tue, 5 Dec 2000 09:16:34 -0500
Message-Id: <10701.123649@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0012_01C05E9C.104A5570 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

In case of INSERT into table with nologging option, to bypass the redo buffer you'll need to use /*+ APPEND */ hint. If truncating a table is an option as opposed to a delete, then that's a way around redo as well.

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of andrey Sent: Tuesday, December 05, 2000 6:31 AM To: Multiple recipients of list ORACLE-L Subject: non-rollback-able DML

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_0012_01C05E9C.104A5570 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 http-equiv=3DContent-Type content=3D"text/html; =

charset=3Diso-8859-1">

<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D484581314-05122000><FONT face=3DArial color=3D#0000ff =

size=3D2>In=20
case of INSERT into table with nologging option, to bypass the redo = buffer=20
you'll need to use /*+ APPEND */ hint. If truncating a table is an = option as=20
opposed to a delete, then that's a way around redo as well.=20 </FONT></SPAN></DIV>
<DIV><SPAN class=3D484581314-05122000></SPAN><FONT face=3DTahoma><FONT = face=3DArial=20

color=3D#0000ff size=3D2></FONT><BR><FONT size=3D2><SPAN=20
class=3D484581314-05122000><FONT face=3DArial=20
color=3D#0000ff>&nbsp;</FONT></SPAN>-----Original =

Message-----<BR><B>From:</B>=20
root_at_fatcity.com [mailto:root_at_fatcity.com]<B>On Behalf Of=20 </B>andrey<BR><B>Sent:</B> Tuesday, December 05, 2000 6:31 = AM<BR><B>To:</B>=20
Multiple recipients of list ORACLE-L<BR><B>Subject:</B> = non-rollback-able=20
DML<BR><BR></FONT></DIV></FONT>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px = solid; MARGIN-RIGHT: 0px">
<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=20
  writing to rollback segments ( in order to improve performance )=20   ?</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=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=20
  =
class=3D563212611-05122000></SPAN></FONT> </DIV></BLOCKQUOTE></BODY>= Received on Tue Dec 05 2000 - 08:16:34 CST