SQL*Net message from client
We are doing some tests in our db & during our tests over four different days,
Looking through the AWR reports of the last four tests, I came across this wait event, 'SQL*Net message from client'.
I have mentioned its readings for the past four tests below. Is this something that’s concerning?
Event Waits %Time-outs Total Wait Time (s) Avg wait (ms) Waits / txn %DB time
SQL*Net message from client 27,584,938 0 825,119 30 18.18
SQL*Net message from client 7,329,416 0 2,557,499 349 6.27
SQL*Net message from client 2,137,218 0 770,839 361 20.39
SQL*Net message from client 12,316,602 0 5,979,316 485 6.89
From what I have read, it says that Oracle db is waiting for the ‘client’ to finish the work. Does that mean there is some delay in the client i.e. PeopleSoft processing the data here? Correct me if I’m wrong. Appreciate your response.
I have mentioned its readings for the past four tests below. Is this something that’s concerning?
Event Waits %Time-outs Total Wait Time (s) Avg wait (ms) Waits / txn %DB time
SQL*Net message from client 27,584,938 0 825,119 30 18.18
SQL*Net message from client 7,329,416 0 2,557,499 349 6.27
SQL*Net message from client 2,137,218 0 770,839 361 20.39
SQL*Net message from client 12,316,602 0 5,979,316 485 6.89
From what I have read, it says that Oracle db is waiting for the ‘client’ to finish the work. Does that mean there is some delay in the client i.e. PeopleSoft processing the data here? Correct me if I’m wrong. Appreciate your response.
0