Lgwr
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Lgwr

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    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

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    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.

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758

    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

  4. #4
    Join Date
    Sep 2002
    Posts
    376
    Hi,
    sanjay u mean to say that it writes parallely,.... how it is possible for a single process to wirte to multiple files simultaneously.

  5. #5
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    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

  6. #6
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    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
    -nagarjuna

  7. #7
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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
  •  



Click Here to Expand Forum to Full Width