Category: PIPER-Rx Reports (Free) Name: FPF001-11 Application Response Time ReportDefFileName: .\FPF001-11 Application Response Time.fr3 ===Begin Comments=== Copyright (C) 2009 G Piper This program is free software: you can redistribute it and/or modify it under the terms of the GNU Affero General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more details. a copy of the GNU Affero General Public Licenses provided is part of the down load Terms and Conditions available on our site www.piper-rx.com or you can refere to www.gnu.org/licenses/gpl.html ===End Comments=== ===Begin SQL=== -- **************************************************** -- ** PIPER-RX - Free Reports -- ** -- ** Copyright (C) 2009 G.Piper -- ** -- ** Simple application response time report (day) -- ** -- ** ------------------------------------------------- -- ** Version 1.0 May-09 G.Piper Initial Creation -- ** Version 1.1 Aug-09 G.Piper Referenced GV$DATABASE -- **************************************************** SELECT to_char(sysdate, 'DD-Mon-YY HH24:MI') report_date, report_headings.sid_name, :SAMPLE_DATE sample_date, trunc(fcr.actual_start_date) actual_start_date, to_char(fcr.actual_start_date, 'HH24:MI') formatted_time, (fcr.actual_completion_date - fcr.actual_start_date)*24*60*60 run_time_sec FROM applsys.fnd_concurrent_requests fcr, ( SELECT vd.name sid_name FROM gv$database vd WHERE vd.inst_id = 1 ) report_headings WHERE fcr.program_application_id = 0 -- FNDOAMCOL and fcr.concurrent_program_id = 44598 -- FNDOAMCOL and trunc(fcr.actual_start_date) = to_date(:SAMPLE_DATE, 'DD-Mon-YY') and fcr.actual_completion_date is not null ORDER by fcr.actual_start_date ===End SQL=== ParamName: SAMPLE_DATE ParamType: String ParamValue: 20-May-09 ParamExp: ===Begin Report Definition===