sandeep vig

• Oct 13th, 2005

 

logswitch occurs when the current logfile becomes full and at logswitch a checkpoint is performed by the checkpoint process

devesh

• Jan 20th, 2006

 

When you give this command 'alter database switch logfile' then he generate a checkpoint number which shows that your courrent redo log is full and he write the second redo log. If you want to information about checkpoint the you have to use this view 'V$datafile'.

Anand Maripalli

• Apr 11th, 2007

 

Just to correct U..


 ITS "alter system switch logfile"; it would switch from one redolog file to another redolog file.

 We can use the view V$LOG (select sequence#, status from v$log) to knw the current used redolog group and the sequence number of the redo's.

Mohammed Abdul Afroze

• Sep 28th, 2007

 

The point at which oracle ends writing from one redo log and begins writing to another is called as a log switch.

nitanjandial

 Profile Answers by nitanjandial 

• Dec 8th, 2007

 

log switch occurs when current redo logfile gets full and lgwr writes redo to next redo logfile.
Even we can perform log switch with the command also
before we execute the sql execute following statement
SQL> select status from v$log;

STATUS
----------------
UNUSED
UNUSED
CURRENT------>active redo logfile 3

After execute the statement

SQL> alter system switch logfile;

System altered.

SQL> select status from v$log;

STATUS
----------------
CURRENT---->now it have changed the position from logfile3 to logfile1
UNUSED
ACTIVE

SQL>


Cheers