Sqlnet message to client wait time is very high.
How can I tune it ?
Does any body has used SDU,TDU, array_size parameters.
Will you please give me the realtime example of sizing this parameters. My block size is 8192k , oracle 8.1.6, linux
Database is connected via apache application server.
Your help is appreciated..
you dont tune that
itīs not really waits, itīs just that the server has nothing to send to the client
No Pando, it is a wait time is increasing database is 24/7.
Due to that some time application server dying.
I can see acvtivities through OEM and spotlight
As pando allready said, this "SQL*Net mesage to client" wait event is not causing you any problems. This is one of those idle wait events in a database that allways grow (and actually consume the most wait time in wait event statistics) but are actually inevitable but have no influence on the performance. You should simply ignore them. Some other idle wait events are:
- pmon timer
- smon timer
- SQL*Net message from client
- SQL*Net more data from client
- rdbms ipc message
- null event
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
well, first, you need verify your indexes and tables, maybe your objects was be fragmented.
Maybe the space reserved for transactions is very small, you need defined with pct inrease and free list paramters...
Click Here to Expand Forum to Full Width