title: If I query from V$SQL view, does it include SQL that are still running and not yet finished?
body: <p>I'm running a query below in an oracle db.</p>
  
  <pre><code>SELECT program_id, program_line#, sql_text
  FROM V$SQL VS ,
       ALL_USERS AU
  WHERE (executions &gt;= 1)
    AND (parsing_user_id != 0)
    AND (AU.user_id(+) = VS.parsing_user_id)
    AND UPPER(AU.USERNAME)  IN (UPPER('CARGO'))
  ORDER BY last_active_time DESC;
  </code></pre>
  
  <p>I just wanted to ask if the result returned by this query includes sql that are still running or query that has timeout or cancelled by the user?</p>