Oracle Current Activity Given below is a small query that provides the following information about…

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…

– Query to find runtime for a concurrent program SELECT /*+ rule */ rq.parent_request_id “Parent…