Home » RDBMS Server » Performance Tuning » lots of waits sql*net
lots of waits sql*net [message #267154] Wed, 12 September 2007 10:41 Go to next message
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
Re: lots of waits sql*net [message #267157 is a reply to message #267154] Wed, 12 September 2007 10:48 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
http://www.oreilly.com/catalog/optoraclep/chapter/ch01.pdf
Re: lots of waits sql*net [message #267186 is a reply to message #267157] Wed, 12 September 2007 12:04 Go to previous message
thorin666
Messages: 144
Registered: March 2007
Senior Member

i am reading thnx so much
Previous Topic: Sql slow query plan
Next Topic: Module in Statspack Report
Goto Forum:
  


Current Time: Fri Dec 02 16:55:39 CST 2016

Total time taken to generate the page: 0.23275 seconds