rem -----------------------------------------------------------------------
rem Filename: appinfo.sql
rem Purpose: Script to display status of all the Concurrent Managers
rem Author: Anonymous
rem -----------------------------------------------------------------------
set head on
column OsId format A10 justify left
column CpId format 999999
column Opid format 999
column Manager format A30
column Status format A20
column Started_At format A30
column Cpid heading 'Concurrent|Process ID'
column OsId heading 'System|Process ID'
column Opid heading 'Oracle|Process ID'
column Manager heading 'Concurrent Manager Name'
column Status heading 'Status|of Concurrent|Manager'
column Started_At heading 'Concurrent Manager|Started at'
select distinct Concurrent_Process_Id CpId, PID Opid,
Os_Process_ID Osid, Q.Concurrent_Queue_Name Manager,
P.process_status_code Status,
To_Char(P.Process_Start_Date, 'MM-DD-YYYY HH:MI:SSAM') Started_At
from Fnd_Concurrent_Processes P, Fnd_Concurrent_Queues Q, FND_V$Process
where Q.Application_Id = Queue_Application_ID
and Q.Concurrent_Queue_ID = P.Concurrent_Queue_ID
and Spid = Os_Process_ID
and Process_Status_Code not in ('K','S')
order by Concurrent_Process_ID, Os_Process_Id, Q.Concurrent_Queue_Name
/
分享到:
相关推荐
Principles.of.Concurrent.and.Distributed.Programming.chm
并发程序的验证方法和基础.对于编写并行程序、并行程序测试、程序正确性验证等方面的同学值得一看
Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications. About the Technology Unlock the incredible performance built into your multi-processor ...
Concurrency in .NET Modern patterns of concurrent and parallel programming
concurrent-all-in-one.pdf
Formal Analysis of Concurrent Java Systems
并发系统的监督控制-Petri网方法 Chapter 1:Introduction Chapter 2: This chapter introduces the Petri nets ...in the process of abstracting concurrent hybrid systems to the DES setting of Chapter 9.
A C++ library of Concurrent Data Structures
Design and Implementation of High Concurrent Communication Server in Health Monitoring System
这个工程是为了学习guava concurrent中的AbstractFuture而建立的,里面有可以运行的例子,再配合我的博客:https://blog.csdn.net/o1101574955/article/details/82889851,可以看明白guava concurrent的基本设计思路...
Method for Estimating the Number of Concurrent Users
Concurrent and parallel programming have progressed from niche disciplines, of interest only to kernel programming and high-performance computing, to something that every competent programmer must ...
Concurrent Managers 3 Login Security 3 User Profiles 3 Attachments 3 Language 3 Key Flexfields 3 Descriptive Flexfields 3 Flexfield Values 3 Set of Books Tables 3 Budget Tables 3 Journal Entry Tables ...
Concurrency in .NET_ Modern patterns of concurrent and parallel programming. With examples in C# and F#
backport-util-concurrent.jarbackport-util-concurrent.jarbackport-util-concurrent.jar
verification of sequential and concurrent programs-third extended edition,一本很实用的英文书
Inside the Oracle Concurrent Manager
concurrent 源代码concurrent 源代码
concurrent.jar web开发工具包
Automatic Verification of Finite-State Concurrent System Using Temporal Logic Specifications