Log file parallel write.

From: Nisha Mohan <NishaMohan_A_at_infosys.com>
Date: Fri, 31 Aug 2012 09:11:05 +0000
Message-ID: <D2EF2C83C5C50B4CB202F0619D5287480230D8_at_BLRKECMBX11.ad.infosys.com>

I have a standalone DB of version 10.2.04.I am facing log file parallel write as one of the top events. I have increased the REDO log file size to 500m.But even then REDO switching is happening frequently. select group#, bytes, archived, status, first_change#, first_time from v$log order BY first_change#;

---------- ---------- --- ---------------- ------------- ----------

        10  262144000 NO  INACTIVE               8509999 30-08-2012
        12  524288000 NO  INACTIVE               8612142 30-08-2012
        11  262144000 NO  INACTIVE               8676390 30-08-2012
         9  262144000 NO  CURRENT                8706330 30-08-2012

Thu Aug 30 13:05:47 2012
Thread 1 advanced to log sequence 2582 (LGWR switch)   Current log# 11 seq# 2582 mem# 0: /redo2/ORAMIG/ORAMIG_DB/ORAMIG_logfile/log_11aORAMIG.dbf Thu Aug 30 13:08:45 2012
Thread 1 advanced to log sequence 2583 (LGWR switch)   Current log# 9 seq# 2583 mem# 0: /redo2/ORAMIG/ORAMIG_DB/ORAMIG_logfile/log_9aORAMIG.dbf

Kindly help me with this.


Thanks and Regards,
Nisha Mohan.A

  • CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS***


http://www.freelists.org/webpage/oracle-l Received on Fri Aug 31 2012 - 04:11:05 CDT

Original text of this message