Category: PIPER-Rx Reports (Free) Name: FCR001-11 Concurrent Requests Summary ReportDefFileName: .\FCR001-11 Concurrent Requests Summary.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 Concurrnt Manager queue content list -- ** -- ** ------------------------------------------------- -- ** Version 1.0 May-09 G.Piper Initial Creation -- ** Version 1.1 Aug-09 G.Piper Referenced GV$DATABASE -- **************************************************** SELECT report_headings.report_date, report_headings.sid_name, fcwr.concurrent_queue_name manager, fcq.running_processes, fcq.sleep_seconds sleep_seconds, fcq.cache_size cache, sum(decode(fcwr.phase_code, 'R', 1, 0)) running, sum(decode(fcwr.phase_code, 'P', 1, 0)) total_pending, sum(decode(fcwr.phase_code, 'P', decode(fcwr.hold_flag, 'Y', 0, decode(sign(fcwr.requested_start_date - sysdate), 1, 0, 1)), 0)) pending_normal, sum(decode(fcwr.phase_code, 'P', decode(fcwr.hold_flag, 'Y', 1, 0), 0)) on_hold, sum(decode(fcwr.phase_code, 'P', decode(sign(fcwr.requested_start_date - sysdate), 1, decode(fcwr.hold_flag, 'Y', 0, 1), 0), 0)) scheduled FROM apps.fnd_concurrent_worker_requests fcwr, applsys.fnd_concurrent_queues fcq, ( SELECT to_char(sysdate, 'DD-Mon-YY HH24:MI') report_date, vd.name sid_name FROM gv$database vd WHERE vd.inst_id = 1 ) report_headings WHERE fcwr.concurrent_queue_id = fcq.concurrent_queue_id and fcwr.concurrent_queue_name != 'FNDCRM' GROUP by report_headings.report_date, report_headings.sid_name, fcwr.concurrent_queue_name, fcq.running_processes, fcq.sleep_seconds, fcq.cache_size ORDER by fcwr.concurrent_queue_name ===End SQL=== ===Begin Report Definition===