Re: Disable logging in tablespace vs using hidden parameter_disable_logging
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <amit.poddar@xxxxxxxx>
- Date: Thu, 2 Feb 2006 20:51:11 -0000
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@xxxxxxxx>
To: <jonathan@xxxxxxxxxxxxxxxxxx>
Cc: <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxxxxxxx>:
--
//www.freelists.org/webpage/oracle-l
Other related posts:
