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>
Hi,
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#;
Date: Fri, 31 Aug 2012 09:11:05 +0000
Message-ID: <D2EF2C83C5C50B4CB202F0619D5287480230D8_at_BLRKECMBX11.ad.infosys.com>
Hi,
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#;
GROUP# BYTES ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- --- ---------------- ------------- ----------
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
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