Re: NoLogging for perfstat tablespace

damorgan wrote:

> 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.

Good point!
I just want to say, for OLTP applications. We got no more benefit from turn off logging in most cases. Just like Daniel said, you'd better check the access plan, collect current statistics, ...
But for those applications which involve heaven update sql requests, I hope I can turn off logging.
Regards,

>
>
> 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 Tue Feb 19 2002 - 21:15:40 CST