Oracle Database Discussions

Hi All,

Oracle 11.2.0.3 on RedHat.

I am trying to find out SQL activity on my database for a very narrow time window. Please see the SQLs I did

SQL> select distinct user_id, sql_id
  2  from v$active_session_history
  3  where sample_time between to_date('20120704012000','yyyymmddhh24miss') and
  4            to_date('20120704012200','yyyymmddhh24miss')
  5  and user_id = 111 ;

   USER_ID SQL_ID
---------- -------------
       111
       111 gjg25k7stx9ba
       111 a8m049aj31b1y
       111 asjw7b7h99w4m
       111 fvffk1aqrb55n
       111 9gskv9b1u7mau
       111 03tsb9pp3h1uj
       111 dm0jppss5z0ay
       111 44n0svyuc000x
       111 16t1tpr7mdqnf
       111 bzpu510tng689
       111 dsqzhqdvzamys

12 rows selected.

SQL> select * from v$sqltext where sql_id='16t1tpr7mdqnf' order by piece ;

no rows selected

SQL> select * from table( dbms_xplan.display_awr('16t1tpr7mdqnf') ) ;

no rows selected

I can see the text for all SQLs in v$sqltext, except 16t1tpr7mdqnf. User id 111 is the user used to run our batch processes.
Where can I find the text for this SQL id 16t1tpr7mdqnf ?
This SQL has run about 8 hours ago.

Thanks in advance