title: SQL_ID found in dba_hist_sqltext but not in v$sql
body: <p>I had a SQL_ID that i was checking in <code>v$sql</code> a few days ago, ga93ryqxj7mcs and bfzp2dt9prncs.</p>
  <pre><code>select  *
  from    v$sql
  where   sql_id in ('ga93ryqxj7mcs', 'bfzp2dt9prncs')
  </code></pre>
  <p>However, when i queried it today, it's gone. i checked <code>dba_hist_sqltext</code> and it's still there:</p>
  <pre><code>select  *
  from    dba_hist_sqltext
  where   sql_id in ('ga93ryqxj7mcs', 'bfzp2dt9prncs');
  </code></pre>
  <p>It's also in <code>dba_hist_sqlstat</code>.
  But i'd like to know the PROGRAM_ID of those 2 SQL_IDs, any other views I can use?</p>