Re: oracle-l Digest V12 #51
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: "dmarc-noreply@xxxxxxxxxxxxx" <dmarc-noreply@xxxxxxxxxxxxx>
- Date: Sun, 22 Feb 2015 09:28:28 -0600
It is not harming performance on the database. It might be overloading your
network a little, but that's really not that huge of a load for a network. You
might chat with the developer to fix it, but it's not something a DBA can fix
himself typically.
Sent from my iPad
> On Feb 22, 2015, at 2:40 AM, walid kaakati (Redacted sender
> "walid_alkaakati@xxxxxxxxx" for DMARC) <dmarc-noreply@xxxxxxxxxxxxx> wrote:
>
> 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@xxxxxxxxxxxxx>
> An: oracle-l digest users <oracle-l@xxxxxxxxxxxxx>
> 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@xxxxxxxxxxxxx> (Redacted sender
> "walid_alkaakati@xxxxxxxxx" 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@xxxxxxxxx>
> 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@xxxxxxxxx" for DMARC) <dmarc-noreply@xxxxxxxxxxxxx> 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
> ******************************
>
>
>
Other related posts:
