SQL_ID missing from v$session when session is "ACTIVE"
From: kyle Hailey <kylelf_at_gmail.com>
Date: Thu, 22 Jul 2021 08:36:04 -0700
Message-ID: <CADsdiQiPwKjq03AMp-U=DLKAYFG99U0=3M1FY5EdYH5XWcMhkg_at_mail.gmail.com>
I'm used to SQL_ID missing from v$session when it's a background process like LGWR but for user sessions I always expect to find a SQL_ID for a session that is "ACTIVE".
Anyone know of examples of why an user session would be missing SQL_ID when ACTIVE? select sid||':'||serial# session_id,
where
/
Date: Thu, 22 Jul 2021 08:36:04 -0700
Message-ID: <CADsdiQiPwKjq03AMp-U=DLKAYFG99U0=3M1FY5EdYH5XWcMhkg_at_mail.gmail.com>
I'm used to SQL_ID missing from v$session when it's a background process like LGWR but for user sessions I always expect to find a SQL_ID for a session that is "ACTIVE".
Anyone know of examples of why an user session would be missing SQL_ID when ACTIVE? select sid||':'||serial# session_id,
username,
s.sql_id||':'||sql_child_number sqlid,
SQL_ADDRESS,
SQL_HASH_VALUE,
command,
decode(state, 'WAITING', wait_class||':'||event, 'CPU') event
from v$session s
where
(( s.wait_time != 0 /* on CPU */ and s.status='ACTIVE' /* ACTIVE */)
or
s.wait_class != 'Idle'
)
/
SESSION_ID USERNAME
- ------------------------------
SQLID SQL_ADDRESS
- ----------------
SQL_HASH_VALUE COMMAND
- ----------
EVENT
36:13933 KYLELF : 00
0 0
SQL*Net message from client
CPU
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 22 2021 - 17:36:04 CEST