Re: reduce archive logs

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Thu, 15 May 2003 15:02:13 +1000
Message-ID: <g0Fwa.34623$1s1.503785@newsfeeds.bigpond.com>

"bcjm" <oldcar_at_hotmail.com> wrote in message news:6e9fcca4.0305140740.f31ff04_at_posting.google.com...
> 8.1.6 running Windows NT,
>
> We have a intranet site done in Cold Fusion using Oracle 8.1.6 as its
> data source. The CF client/session variable data (CDATA, CGLOBAL) are
> stored in the Oracle database as well. CF server updates/insert
> records in these tables when user access the site. It generates more
> than 100MB archive log daily. I like to eliminate the logs generated
> by these two tables if possible to save space and improve performance.
> I really don't need the data in these tables if I need to restore the
> database.
>
> Setting these table to no archive log does not help since it only
> works in limited situations like in batch/direct load.
>
> Any suggestions?

100MB isn't exactly enormous, you know.

But if NOLOGGING isn't helping (and I wouldn't expect it to), then there's nothing you can do about it. If Oracle feels redo needs to be generated, then generated it must be, and the best you can do about it is to manage the situation.

But again: 100MB is not the worst management scenario I've come across!

Regards
HJR Received on Thu May 15 2003 - 00:02:13 CDT