Re: Optimization

From: Peter Mubaiter <this.is.not.valid_at_spammer.hola>
Date: Fri, 14 Jan 2005 18:22:38 +0100
Message-ID: <1105723385.1f32c810b19f44f483c63fa3cfc6b10c@teranews>

Holger Baer schrieb:
> Peter Mubaiter wrote:

>> I think that most of the database out there will have a high value for 
>> wait event "SQL*Net message from client". I know nearly no application 
>> which opens a session, requests data, fetches the data and closes the 
>> session again (that'll keep this specific wait event low).
>>

>
> Webbased applications (e.g jsp or asp) do exactly this. If you don't have
> a fully grown Application Server, that's what you get.

That's why I wrote "I know nearly no application..." because the apps I saw connecting to Oracle make use of connection pooling etc. Applications, where performance is a must, because reopening sessions take too much time. The other apps were using mySQL etc. ;-) But we are now a mile away from the original posters question. To summarize: A high value of SQL*Net% can indicate a problem. It has to be further investigated.

Regards,

Peter Received on Fri Jan 14 2005 - 11:22:38 CST