Database Tuning (MOSC)

MOSC Banner

ADR file lock ?? help..

edited Jul 27, 2018 12:52PM in Database Tuning (MOSC) 11 commentsAnswered

Release:

11.2.0.1.0 std 32bit


OS:

Number of CPUs:                                16                16

Number of CPU cores:                          8                  8

Number of CPU sockets:                        2                 2

Physical memory, MB:                    18268          18268

Linux db1 2.6.18-238.el5PAE #1 SMP Sun Dec 19 14:42:44 EST 2010 i686 i686 i386 GNU/Linux

Top 10 Wait Events

                                                                                Avg   %Total   %Total

                                                                                Wait       Call    Elapsed

Event                                        Waits     Time (s)  (ms)     Time   Time       Wait Class

---------------------------                    -----      --------     ----     ------      -------  ----------

ADR file lock                                43       67.1     15.6     78.5    279.7  Other

CPU time                                                 17.3                  20.3      72.2  On CPU

direct path write temp                  61        0.4        0.1       0.5         1.6  User I/O

log file sync                                   12        0.2        0.2       0.2         0.9  Commit

log file parallel write                     24        0.2        0.1       0.2         0.9  System I/O

control file parallel write                 8        0.2        0.2       0.2         0.7  System I/O

db file async I/O submit                  1        0.0        0.1       0.0         0.1  System I/O

direct path read                          349        0.0        0.0       0.0         0.1  User I/O

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