high waits in SQL*Net message from client

[parisdba]

Hi,

could anybody tell me what 'SQL*Net message from client' waits mean and what i should do decrease

1 select SUBSTR(EVENT,1,27),TOTAL_WAITS,TOTAL_TIMEOUTS,
2 TIME_WAITED from v$system_event where time_waited<>0
3* order by time_waited desc
SQL> /

SUBSTR(EVENT,1,27) TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED
--------------------------- ----------- -------------- -----------
SQL*Net message from client 406316 0 1877659
rdbms ipc message 195937 9199 330305
db file sequential read 241399 0 162805
pmon timer 3253 3235 111827
db file scattered read 66828 0 84543
smon timer 34 31 30720
SQL*Net more data to client 302850 0 18343
direct path read 15428 0 14582
direct path write 3466 0 9635
file open 2304 0 3230
latch free 7777 7638 2764
buffer busy waits 1271 2 1578
db file parallel write 1587 0 1577
control file parallel write 3242 0 1251
log file parallel write 64815 0 1170
db file parallel read 873 0 755
log file sync 63473 49
602
control file sequential rea 595 0 12
SQL*Net break/reset to clie 185 0 9
SQL*Net message to client 406433 0 4
LGWR wait for redo copy 158 2 3
SQL*Net more data from clie 50 0 2

 

[spenglerr]

Hi,

the 'SQL*Net message from client' waits mean waits for user inputs.

The following items are typical IDLE-items in the wait-statistics:

SQL*Net message from client } Process waiting for data from the
SQL*Net more data from client} client application
client message }
rdbms ipc message - Usually background process waiting for work
pipe get - DBMS_PIPE read waiting for data
Null event - Miscellaneous
pmon timer - PMON waiting for work
smon timer - SMON waiting for work


That's it.

 

[spenglerr]

Oh, I forgot to answer the second part of your question:

You cannot do anything else to decrease these waits than get your user to work more on the database when they are connected.