Performance - EBS (MOSC)

MOSC Banner

How to Relate Log file Parallel Write wait events in AWR

edited Jan 20, 2016 10:00AM in Performance - EBS (MOSC) 1 commentAnswered

Hello

I am seeing the following in AWR for a process taking 13 hours now after a patch which should be 30 Min normally earlier.

Any body can help urgently to tell me what should be next steps to investigate ?

Background Wait Events

  • ordered by wait time desc, waits desc (idle events last) 
  • Only events with Total Wait Time (s) >= .001 are shown 
  • %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
log file parallel write6,422,976012,31420.6349.96
gcs log flush sync484,42561,18120.054.79
db file parallel write298,015096330.033.91
log file sequential read

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center