ASH view SQL_EXEC_START anomaly
Hi
19.6 (same for 19.9)
I noticed something strange with v$active_session_history view with specific sql_id=f3yfg50ga0r8n.
Well, take for example, these results.
If you check sql_exec_start and sample_time, then it seems like that sql_id had taken almost 38 minutes. However, this row is the only sample in v$active_session_history
Query that I used for this (so I did search all the rows for this specific session), I did put current time also there, so the results ageing out also not the problem here:
SQL> select sysdate, inst_id, sample_time, sql_exec_start, session_id, session_serial#, session_type, sql_id from gv$active_session_history where session_id||','||session_serial#||',@2' = '1160,44696,@2'; SYSDATE INST_ID SAMPLE_TIME SQL_EXEC_START SESSION_ID SESSION_SERIAL# SESSION_TYPE SQL_ID 03.12.2020 00:39:53 2 02.12.2020 23:05:27.486 02.12.2020 23:05:27 1160 44696 BACKGROUND 9x2prazfz86dz 03.12.2020 00:39:53 2 02.12.2020 23:03:21.481 02.12.2020 22:25:02 1160 44696 BACKGROUND f3yfg50ga0r8n 03.12.2020 00:39:53 2 02.12.2020 21:50:57.408