https://oracleracdba1.wordpress.com/2012/09/18/script-to-generate-awr-reports-for-all-snap_ids-between-2-given-dates/ gen_batch.sql set echo off heading off feedback off verify off select ‘Please enter dates…

SELECT DISTINCT * FROM ( select usr.user_name user_name ,ses.sid||’,’||ses.serial# sid_serial from apps.icx_sessions i ,apps.fnd_logins l…