Database Tuning (MOSC)

MOSC Banner

Why there is no corresponding row in V$SQL table giving existing SQL_ID from V$SESSION as query cond

edited Jun 13, 2018 2:50PM in Database Tuning (MOSC) 3 commentsAnswered

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 MACHINEPROCESSLOCKWAIT STATUS   SQL_ID   SQL_ADDR SQL_EXEC_ SQL_EXEC_ID ACTIONLAST_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

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