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: NOLOGGING option

Re: NOLOGGING option

From: TurkBear <jgreco1_at_mn.rr.com>
Date: Thu, 25 Apr 2002 16:16:32 -0500
Message-ID: <1gsgcucpal81c22mcofar2heg0oudhbpk5@4ax.com>

Just to check:
You are using an APPEND hint on the insert to enable Direct Mode so that nologging will work?

"Steven" <steven.pannell_at_gmx.net> wrote:

>Hi,
>
>I have an update statement which selects and updates some 300,000 rows of
>data. Even though I have the NOLOGGING option enabled on the table and
>tablespace i have noticed that the data is still been written to the redo
>logs, this causes a high level of log switching. Is there any way to
>disable the logging and writing of data to the redo logs as the NOLOGGING
>option does not seem to work in the way I would like.
>
>I'm using Oracle 8.1.7 on Solaris.
>
>Thanks,
>Steve.
>
>

-----------== Posted via Newsfeeds.Com - Uncensored Usenet News ==----------

   http://www.newsfeeds.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Ulimited Fast Downloads - 19 Servers =----- Received on Thu Apr 25 2002 - 16:16:32 CDT

Original text of this message

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