-
Lgwr
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.
-
Re: Lgwr
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
-
Hi,
sanjay u mean to say that it writes parallely,.... how it is possible for a single process to wirte to multiple files simultaneously.
-
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
-
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|