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@xxxxxxxxx> 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@xxxxxxxxxx> 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. ****
