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
Printable View
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
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.
There is only one LGWR process no matter how many members you have. LGWR will right parallaly to all members.Quote:
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
Sanjay
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...Quote:
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.
http://otn.oracle.com/docs/products/...eredo.htm#3873
Sameer
time slicing :D :D :DQuote:
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.Quote:
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.
Note that I said redo log memebers not groups.
Sanjay