Re: Disable logging in tablespace vs using hidden parameter_disable_logging

No.

The entire set of redo log activity takes place - so the log writer assumes it has written the log despite not calling the final fwrite, iops, or whatever subroutine. So it thinks it is filling a file, and it still does a logswitch and checkpoint at the correct moment.

Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html Cost Based Oracle: Fundamentals

http://www.jlcomp.demon.co.uk/appearances.html Public Appearances - schedule updated 10th Jan 2006

• Original Message ----- From: <amit.poddar_at_yale.edu> To: <jonathan_at_jlcomp.demon.co.uk> Cc: <oracle-l_at_freelists.org> Sent: Thursday, February 02, 2006 8:35 PM Subject: Re: Disable logging in tablespace vs using hidden parameter_disable_logging

> since log writer is not writing to the file then we should not have any log
> switches so except for incremental checkpoints we should not have complete
> checkpoints resulting from log switches. Correct ?
>
> Quoting Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>:
>
>>

--
http://www.freelists.org/webpage/oracle-l