Lgwr

[bang_dba]

hi,
If i have multiple members in one redo log group, the LGWR, writes
to all the members; does it write serially or does oracle starts more number of LGWR's to do the job

[ggnanaraj]

When multiplexing online redo log files, LGWR concurrently writes the same redo log information to multiple identical online redo log files


http://technet.oracle.com/docs/produ...inere.htm#3981

HTH.

[SANJAY_G]

Originally posted by bang_dba
hi,
If i have multiple members in one redo log group, the LGWR, writes
to all the members; does it write serially or does oracle starts more number of LGWR's to do the job

There is only one LGWR process no matter how many members you have. LGWR will right parallaly to all members.

Sanjay

[bang_dba]

Hi,
sanjay u mean to say that it writes parallely,.... how it is possible for a single process to wirte to multiple files simultaneously.

[Sameer]

Originally posted by bang_dba
Hi,
sanjay u mean to say that it writes parallely,.... how it is possible for a single process to wirte to multiple files simultaneously.

It writes concurrently / paralelly...

http://otn.oracle.com/docs/products/...eredo.htm#3873

Sameer

[nagarjuna]

Originally posted by bang_dba
Hi,
sanjay u mean to say that it writes parallely,.... how it is possible for a single process to wirte to multiple files simultaneously.

time slicing

[SANJAY_G]

Originally posted by bang_dba
Hi,
sanjay u mean to say that it writes parallely,.... how it is possible for a single process to wirte to multiple files simultaneously.

It does write parallaly to redo members.
Note that I said redo log memebers not groups.

Sanjay