reduce the number of indexes on the tables
"bcjm" <oldcar_at_hotmail.com> schrieb im Newsbeitrag
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?
Received on Wed May 14 2003 - 16:11:56 CDT
