RE: Log file sync and log file parallel write.

Reverting back to your perceived I/O problem....  

You say elapsed time for these reports is 45 mins, whats the db time?  

I think that you need to look at the response times for the direct path write/log file parallel write/log file syncs events and whether timeouts are occurring. I would look at the average response time/timeout figures from the wait event section. I would also look at the histogram info from v$event_histogram. Further during the problem period look at the disk %busy figure using iostat. Filesystem type and mount options would also be useful info.  

Post some of this and we might be able to see if you actually have an i/o issue.  

HTH Adrian  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Johnson, William L (TEIS)
Sent: 03 March 2008 19:01
To: oracle-l_at_freelists.org
Subject: Log file sync and log file parallel write.  

I know this topic has been discussed in the past as I have found many threads. I have been trying to sift through the various postings on Freelists and on Metalink, but my head is spinning. Here is the situation…  

Solaris release 5.9.

Enterprise Edition Oracle 9.2.0.6. (Yeah – I know – upgrade – but the third party vendor doesn’t support a newer release with the current version of their software. The application upgrade is not scheduled until May and I have to stop the application from crashing the database through our cluster monitoring tools while index rebuilds are occurring.)  

<snip>

No virus found in this incoming message. Checked by AVG.
Version: 7.5.518 / Virus Database: 269.21.7/1322 - Release Date: 09/03/2008 12:17

No virus found in this outgoing message. Checked by AVG.
Version: 7.5.518 / Virus Database: 269.21.7/1322 - Release Date: 09/03/2008 12:17  

--
http://www.freelists.org/webpage/oracle-l