Re: NoLogging for perfstat tablespace

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 20 Feb 2002 16:47:02 +0100
Message-ID: <j2h77u88ob734c8l10ckke4r6ugu2ebrib@4ax.com>

On 20 Feb 2002 01:10:05 -0800, edzard_at_volcanomail.com (Edzard) wrote:

>You are right, ALTER TABLESPACE .. NOLOGGING has zero effect. I just
>confirmed this when importing a 2G database in Oracle9i 9.0.1.2, into
>a nologging tablespace. So don't worry about the overhead of logging.
>But .. only if this refers to the logging/nologging option on the
>tablespace. Writing the redo logs is overhead for sure and the idea to
>turn it off makes much sense to me too

I guess you are
a) working with a development database
b) don't really know what the purpose of the online redolog is, and why you can't and shouldn' turn it off
c) are in for a career change

Turning of redolog makes no sense at all, unless

a) you don't ever have a power outage
b) you don't ever have a disk crash
c) the data can be safely trashed as the contents are unimportant to

the company you are working for.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Feb 20 2002 - 09:47:02 CST