OraFAQ Forum: Performance Tuning » lots of waits sql*net

Home » RDBMS Server » Performance Tuning » lots of waits sql*net

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

lots of waits sql*net [message #267154]

Wed, 12 September 2007 10:41

thorin666
Messages: 144
Registered: March 2007

Senior Member

i am running statspack and in event wait i see
SQL*NET message from client and SQL*NET message to client events have a lot of waits.
i was reading and maybe is a bad sql
i don't know what to see
here you can see part of my statspack

                                                %Time Total Wait   wait    Waits
Event                                    Waits  -outs   Time (s)   (ms)     /txn
--------------------------------- ------------ ------ ---------- ------ --------

SQL*Net message from client            604,599      0     34,897     58     10.4
Streams AQ: qmn slave idle wait            170      0      4,662  27423      0.0
Streams AQ: qmn coordinator idle           347     51      4,662  13435      0.0
Streams AQ: waiting for time mana            1    100        521 ######      0.0
class slave wait                             1    100          5   4883      0.0
SQL*Net message to client              604,617      0          1      0     10.4
SQL*Net more data from client            5,802      0          1      0      0.1

thnx for your help

Report message to a moderator