Log file parallel write.

From: Nisha Mohan <NishaMohan_A@xxxxxxxxxxx>
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 31 Aug 2012 09:11:05 +0000
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***

--
//www.freelists.org/webpage/oracle-l
Log file parallel write.

Other related posts:
