Why there is no corresponding row in V$SQL table giving existing SQL_ID from V$SESSION as query cond
Hi experts,
DB is 11.2.0.3, could you explain why this is happening? Thanks
Q1 --
select sid,machine,process,LOCKWAIT,STATUS,SQL_ID,SQL_ADDRESS,SQL_EXEC_START,SQL_EXEC_ID, ACTION,LAST_CALL_ET,BLOCKING_SESSION,SECONDS_IN_WAIT from v$session where username = 'OSM_PROD' order by 2,1;
SID MACHINE | PROCESS | LOCKWAIT STATUS SQL_ID | SQL_ADDR SQL_EXEC_ SQL_EXEC_ID ACTION | LAST_CALL_ET BLOCKING_SESSION SECONDS_IN_WAIT |
---------- ---------- ---------- -------- -------- ------------- -------- --------- ----------- ---------- ------------ ---------------- ---------------
1994 <machinename> 1234 ACTIVE 2npw8ymayb64z (RAW) 220 219
--- without any delay
Q2
select SQL_ID,LOADED_VERSIONS,OPEN_VERSIONS,EXECUTIONS,LOADS,DISK_READS,BUFFER_GETS,APPLICATION_WAIT_TIME,CPU_TIME,ELAPSED_TIME