Users complain about some long running process, I checked the database and
I see this:
1 select s.sid, s.sql_id, s.prev_sql_id, last_call_et, sql_exec_start,
START_TIME, USED_UBLK
2* from v$transaction t, v$session s where t.ses_addr = s.saddr
SYS@PROD> /
SID SQL_ID PREV_SQL_ID LAST_CALL_ET SQL_EXEC_START
START_TIME USED_UBLK
---------- ------------- ------------- ------------ -----------------
-------------------- ----------
152 g0ddassbxdnjm 14d7z6mh1sxuz 1923 04-AUG-17 10:17pm
08/04/17 22:16:17 1
262 2g0db7a4v82j0 3yrm7p2dan49j 24279 04-AUG-17 10:30pm
08/04/17 21:54:16 28
388 2nt4pv6nacb1t 96g93hntrzjtr 1922 04-AUG-17 10:31pm
08/04/17 22:31:37 1
What is going on with sid 262 and why is there so much discrepancy between
last_call_Et, SqlExecStart, and tx.start time?
TIA, CP