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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Johnson, William L (TEIS)
Sent: 03 March 2008 19:01
To: oracle-l@xxxxxxxxxxxxx
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
 

Other related posts: