reduce archive logs

From: bcjm <oldcar_at_hotmail.com>
Date: 14 May 2003 08:40:24 -0700
Message-ID: <6e9fcca4.0305140740.f31ff04@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? Received on Wed May 14 2003 - 10:40:24 CDT