http://oracleprof.blogspot.com/2011/06/how-to-color-mark-sql-for-awr-snapshots.html essentially you tell AWR to capture that SQL always if it is available. Raj -- //www.freelists.org/webpage/oracle-l