Database Tuning (MOSC)

MOSC Banner

I have problem times responses with wait

edited Oct 25, 2011 4:07AM in Database Tuning (MOSC) 15 comments
hello,

     I have a problem times response of my appliaction, and I would like prove that it's not a problem of my database.

1 - I have executed this query for the wait event :

        select event, sum(seconds_in_wait) secs_in_wait from v$session_wait group by eve

        the result is

         EVENT                                                                                   SECS_IN_WAIT
----------------------------------------------------------------                   ------------
SQL*Net message from client                                                              252392
Streams AQ: qmn coordinator idle wait                                               163673
pmon timer                                                                                              46731
Streams AQ: waiting for time management or cleanup tasks                13541
rdbms ipc message                                                                                11551
Streams AQ: qmn slave idle wait                                                             3465
smon timer                                                                                                  290
Streams AQ: waiting for messages in the queue                                          3
SQL*Net message to client                                                                             0

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