Re: state vs status

Hi.

state is only ever meaningful if status is active, Otherwise, it's just the value of the *last* wait state.

On Wed, Aug 1, 2018 at 3:33 PM 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. ****
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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