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
Message-Id: <87527918-4D62-417B-A8B7-6C7BEDE0F758_at_gmail.com>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Feb 21 2015 - 11:36:23 CET

Original text of this message