Re: NoLogging for perfstat tablespace

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Mon, 18 Feb 2002 21:17:32 GMT
Message-ID: <3C716F79.DD99C346@ci.seattle.wa.us>

Likely a complete waste of time. 95% of the time when people starting worrying about the overhead of logging ... they either have no real performance problem ... or they have not run EXPLAIN PLAN, TKPROF, and DBMS_PROFILER against their application.

In most cases, there is more to be gained from one good index than there is from nologging.

Daniel Morgan

Stan wrote:

> am planning to have nologging turned on for perfstat tablespace as my
> statpack's snap might run every hour, whereby avoiding the overhead that
> it might create like writing rollbacks, filling up redologs..etc
>
> Is this a good idea ? any dis-advantages....
>
> -Stan
Received on Mon Feb 18 2002 - 15:17:32 CST