Re: ORCLALRT.LOG doesn't contain timestamps!

trea wrote:
>
>
> everytime your redo logs switch your SGA is flushed. this clears out your
> db block buffers, shared pool, etc.

What a load of rubbish - modified buffers from the buffer cache are written (copied, really) to the datafiles on disk as part of a checkpoint which occurs at an impending log switch.

One the checkpoint is complete, the contents of the red log buffer are then written out to the redo log files.

The shared pool is not touched! No buffers are removed from the buffer cache. No data dictionary information in lost.

Why can't some people read the manuals before the give advice???

David P.

Oracle Certified DBA.