Re: state vs status

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Wed, 1 Aug 2018 17:48:42 +0300
Message-ID: <CAOVevU4==xcYVTLvfjneOTEfieyZxSYsV1FTkJXE+hMy+5B+Pw_at_mail.gmail.com>

Hi Matt,

You can use the following example to get real current session state: select
  case

     when s.status = 'ACTIVE'
       then case when s.state='WAITING' then s.event
                 else 'ON CPU'
            end
     else s.status

  end event_status
,s.*
from v$session s;

On Wed, Aug 1, 2018 at 5:45 PM, Harel Safra <harel.safra_at_gmail.com> wrote:

> Sqlnet message from client is an idle wait.
> https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::p11_question_id:
> 1860804200346441327
>
> On Aug 1, 2018 17:32, "Matt Adams" <MAdams_at_equian.com> wrote:
>
> I have multiple oracle forms connections to a 11.2.0.4 database.
>
>
>
> The status is inactive, the state is ‘WAITED SHORT TIME’ (for “SQL*Net
> from client”) and the SQL_ID is NULL.
>
>
>
> The status implies that it is idle, but the state implies that it is
> doing something (because it’s not waiting), but I can’t figure out what it
> is doing.
>
>
>
> Is there any way to determine what’s going on with this session?
>
>
>
>
>
> Matt
>
>
>
> **** This communication may contain privileged and/or confidential
> information. If you are not the intended recipient, you are hereby notified
> that disclosing, copying, or distributing of the contents is strictly
> prohibited. If you have received this message in error, please contact the
> sender immediately and destroy any copies of this document. ****
>
>
>

-- 
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 01 2018 - 16:48:42 CEST