title: How do I get the next-to-last register for a select statement?
body: <h2>Environment</h2>
  
  <p>Virtual machine with OracleXE11g (I'm using <code>SQL Plus</code>)</p>
  
  <h2>Explanation</h2>
  
  <p>I need to get with 1 query (and without <code>pl/SQL</code>):  </p>
  
  <ul>
  <li>The last <code>SQL</code> statement that was executed in the server</li>
  <li>The number of times that statement was executed since It was first loaded in the Shared Pool</li>
  <li>The CPU time it took of executing for that same statement</li>
  </ul>
  
  <p>All in all, this is the query that I figured out</p>
  
  <pre><code>SELECT sq.SQL_TEXT ,sq.EXECUTIONS, sq.CPU_TIME
    FROM gv$sql sq;
  </code></pre>
  
  <p>Of course, this query is working, but it shows all the registers. I need to get the next-to-last one, because the last one would be that same query when It got executed.</p>
  
  <h2>What I'm trying to achieve</h2>
  
  <p>How could I get the next-to-last register of that query?</p>