Re: reduce archive logs

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Wed, 14 May 2003 19:10:48 +0200
Message-ID: <p2u4cvotushj6shbo00il4bhnobl40gljr@4ax.com>

On 14 May 2003 08:40:24 -0700, oldcar_at_hotmail.com (bcjm) wrote:

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

100 Mb *ONLY* and you want to reduce that? On your -no doubt- 36G hard drive?

ROFL
LMAO Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed May 14 2003 - 12:10:48 CDT