Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: reduce archive logs
"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.
Don't store the data in the database, store it in Cookies its exactly what they are designed for.
-- Niall Litchfield Oracle DBA Audit Commission UKReceived on Thu May 15 2003 - 13:18:32 CDT