Re: Optimization

From: Peter Mubaiter <this.is.not.valid_at_spammer.hola>
Date: Fri, 14 Jan 2005 15:31:19 +0100
Message-ID: <1105713104.e1dd7ad348d085466941abe2600ab3c2@teranews>

Ask DBA schrieb:
> I have a hight value for SQL*Net message to client and
> SQL*Net message from client
> how to decrease these values

Optimize your application, tell the users to type faster, install gigabit network.

OK, that wasn't funny. A wait event "SQL*Net message from client" means that the sessions awaits requests from the client. The server process is idle waiting on client requests. That is nothing to worry about and quite normal as there is no constant data exchange from the client to the server.
"SQL*Net message from client" means that the server process is sending data to the client. Also nothing to worry about.

HTH, Peter Received on Fri Jan 14 2005 - 08:31:19 CST