Database Tuning (MOSC)

MOSC Banner

Imm op wait event

edited Oct 26, 2010 9:38AM in Database Tuning (MOSC) 2 commentsAnswered
 Hi,

I ran a ADDM report in my environment which says "imm op" wait event should be tuned. I am trying to figure out what this wait event does? Can you guys help me to sovle this? In AWR report i have Elapsed time : 30,550.30 (mins) and DB Time: 129,813.56 (mins).

FINDING 1: 41% impact (515259 seconds)
--------------------------------------
Wait event "imm op" in wait class "Other" was consuming significant database
time.

   RECOMMENDATION 1: Application Analysis, 41% benefit (515259 seconds)
      ACTION: Investigate the cause for high "imm op" waits. Refer to Oracle's
         "Database Reference" for the description of this wait event.

   RECOMMENDATION 2: Application Analysis, 41% benefit (515259 seconds)
      ACTION: Investigate the cause for high "imm op" waits in Service

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