Re: oracle-l Digest V12 #51
Date: Sun, 22 Feb 2015 08:40:32 +0000
Message-ID: <505629597.6679752.1424594431505.JavaMail.yahoo_at_mail.yahoo.com>
Hallo Steve,
This source of problem appears with procedures that run on the client side, with lot of traffic between client and server side I can see a report with 50000 rows with only one fetch per round trip !, they are not database procedures,our server now is 64 RAM ,six SSD drives ,before on the old server we have only problems with slow reading I mean sequential waits, My question is because of the bad coding of the application, with powerful server this waiting event is harming the performance ? because oracle is sitting doing nothing just waiting for client to respond and send new request so we have to modify these reports and procedures? I mean where I should investigate more? Best wishes
Von: FreeLists Mailing List Manager <ecartis_at_freelists.org> An: oracle-l digest users <oracle-l_at_freelists.org> Gesendet: 7:05 Sonntag, 22.Februar 2015 Betreff: oracle-l Digest V12 #51
oracle-l Digest Sat, 21 Feb 2015 Volume: 12 Issue: 051
In This Issue:
Help on wait event SQL*Net message from client
Re: Help on wait event SQL*Net message from client
Date: Sat, 21 Feb 2015 10:23:04 +0000 (UTC) From: "walid kaakati" <dmarc-noreply_at_freelists.org> (Redacted sender "walid_alkaakati_at_yahoo.com" for DMARC) Subject: Help on wait event SQL*Net message from client
Hi list,
We are upgrading from 10g to 11.2 database, and can see performance issue, AWR report shows the cause is
this wait event (SQl*NET message from client)
does this have anything to do with system statistics gathering or a bug or where is should look to see the cause?
Best wishes
Subject: Re: Help on wait event SQL*Net message from client From: Steve Karam <oraclealchemist_at_gmail.com> Date: Sat, 21 Feb 2015 05:36:23 -0500
Walid,
Generally SQL*Net message from client means Oracle is just waiting on something to do; you have a session connected and Oracle is waiting for a command so it can do something. If you're thinking that this is the cause of a performance issue, there's likely another underlying issue such as the application connecting but not running any statements (which is not an Oracle issue but would appear to the end user as a performance problem), or you're looking in the wrong place for the source of the problem.
What type of report or query are you using that indicates this is a problem?
Steve Karam
OracleAlchemist.com
> On Feb 21, 2015, at 5:23 AM, walid kaakati (Redacted sender "walid_alkaakati_at_yahoo.com" for DMARC) <dmarc-noreply_at_freelists.org> wrote:
>
> Hi list,
>
> We are upgrading from 10g to 11.2 database, and can see performance issue, AWR report shows the cause is
> this wait event (SQl*NET message from client)
> does this have anything to do with system statistics gathering or a bug or where is should look to see the cause?
>
>
> Best wishes
End of oracle-l Digest V12 #51
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Feb 22 2015 - 09:40:32 CET