Database Administration (MOSC)

MOSC Banner

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	        	      

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center