Hi

If you are on 10g and have AWR liscence you can mine the AWR table to get this

DBA_HIST_SQLTEXT

regards
Hrishy