title: How to find last 10 oracle queries by username?
body: <p>Not sure if this is possible.  I'm on 10g.  The end result would look like this:</p>
  
  <pre><code>Username      | Date/Time            | sqltext 
  jdoe          | 3/21/11 10:32:27     | select sum(total) from sales where in_date &gt; '08-JAN-11' 
  jdoe          | 3/21/11 10:32:21     | delete from products_old 
  jdoe          | 3/21/11 10:32:18     | select item, description from products where item = 'blah' 
  jdoe          | 3/21/11 10:32:06     | select count(item) from products 
  jdoe          | 3/21/11 10:31:44     | describe products
  </code></pre>
  
  <p>It looks like v$sql stores almost(?) all of the sql queries ever sent, but what do I join that to to get a username, and date?</p>