Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: NOLOGGING option
"TurkBear" <jgreco1_at_mn.rr.com> wrote in message
news:1gsgcucpal81c22mcofar2heg0oudhbpk5_at_4ax.com...
>
> Just to check:
> You are using an APPEND hint on the insert to enable Direct Mode so that
nologging will work?
Yes, but it still seems to generate a large amount of logging. But performance is noticeably better.
>
> "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 Fri Apr 26 2002 - 03:11:14 CDT