Re: archives

Shawn Belaire - Sun Ottawa SSE wrote:
>
> Has anbody seen a high turn over of log files on a fairly static
> system. Archiving is filling up a lot of space , user says that
> nothing is going on.

If there is no updates (including inserts), ORACLE will not generate any redo log data. Matter of facts, ORACLE will NOT generate redo log data even when there is database activities that does NOT involved updates.

-Ted.

-- 
=============================================
= Theodore Do                               =
= Technical Consultant, UNIX/ORACLE         =
= TRW Information Technology Services       =
= theodore.do_at_trw.com                       =
=============================================