Database Tuning (MOSC)

MOSC Banner

Event: ARCH wait on SENDREQ

edited Dec 28, 2009 1:59PM in Database Tuning (MOSC) 3 commentsAnswered
 I see the  "ARCH wait on SENDREQ" event as the top most event always. Here are my top 5:

Event                                               Waits    Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
ARCH wait on SENDREQ                                  310         413    50.98
db file scattered read                             20,674         159    19.66
CPU time                                                          156    19.21
db file sequential read                            11,801          69     8.52
SQL*Net more data to client                       106,682           4      .46
          -------------------------------------------------------------

We just implemented Standby database. Log archive destination parameters defined as,

log_archive_dest_1                   string      LOCATION=F:\arch\VOYOPER
log_archive_dest_2                   string      service=VOPRSTBY arch reopen=6

Please guide me how can I tune this as I see some slowness due to the above "ARCH wait on SENDREQ".

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center