title: View SQL History by User [Oracle]
body: <p>I'm trying to find all (available) SQL history by user in our Oracle 11g database.  I've tried using some view such as <code>v$sql_monitor</code>, <code>v$sqlarea</code>, and <code>dba_hist_active_sess_history</code> to try to get usernames, and their executed SQL statements (joined on SID and Serial #) but I'm not having any luck.  Our senior DBA and DBE said they've done it before but just told me to look in sqlarea since that has the longest history of SQL held.  I'm not having any luck with this.   Is this possible to do in Oracle?</p>
  
  <p>Edit: We use SQL Developer.  I understand that TOAD may or may not have this feature built-in but I haven't been able to find anything that accomplishes this (other than view current sessions and current SQL) in SQL Developer.</p>