title: Why does not SELECT query start the transaction? [Oracle]
body: <p>I am trying to debug next oracle procedure:</p>
  
  <pre><code>create or replace PROCEDURE CASE_6_TRANS_2
  AS
     V_NUM NUMBER(38,0);
  BEGIN
    SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
    SELECT COUNT(AE.ID) INTO V_NUM FROM AUDIT_EVENT AE WHERE ID=10; 
    COMMIT; --BREAKPOINT
  END CASE_6_TRANS_2;
  </code></pre>
  
  <p>But when I want to see current transaction at breakpoint , the V$TRANSACTION table is empty.</p>
  
  <p>The <a href="http://docs.oracle.com/cd/E11882_01/server.112/e10713/transact.htm#CNCPT016" rel="nofollow">documentation</a> says:</p>
  
  <blockquote>
    <p>A transaction begins when the first executable SQL statement is encountered. An executable SQL statement is a SQL statement that generates calls to a database instance, including DML and DDL statements and the SET TRANSACTION statement.</p>
  </blockquote>
  
  <p>According to <a href="http://docs.oracle.com/cd/B12037_01/server.101/b10759/statements_1001.htm#i2099257" rel="nofollow">documentation</a> <strong>SELECT</strong> query is the <strong>DML</strong></p>
  
  <ol>
  <li>Does transaction starts but it is not shown in V$TRANSACTION?</li>
  <li>Or transaction does not starts at all. Why if not?</li>
  </ol>