How to find no of active concurrent requests
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to find no of active concurrent requests

  1. #1
    Join Date
    Aug 2000
    Posts
    13
    Hi all

    How would I be able to find the active concurrent requests from Oracle Database, Remember I need SQL, I dont want to do it through Oracle Apps

    Everywhere I looked keeps history, I dont want history how do i find the current scheduled requests

    Regards
    Irfan Khan

  2. #2
    Join Date
    Jul 2002
    Posts
    3
    Hi

    please run the following sql


    select * from fnd_concurrent_request where status_code = 'R'

    It will display running concurrent request.


    select * from fnd_concurrent_request where status_code ='P'
    and phast_code = 'I'

    it will display scheduled concurrent requests.

    If you want script please reply me i will sent detail scripts.


    regards

    nutmut

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width