This discussion is archived
2 Replies Latest reply: Feb 4, 2013 6:23 PM by 986056 RSS

Doubt on concurrent request

986056 Newbie
Currently Being Moderated
Hi,

I have a doubt. Is there a DB session associated with every concurrent request or not. Because sometimes a request is running/pending but am not able to fetch associated session from the database. Please confirm !

Thanks
  • 1. Re: Doubt on concurrent request
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    983053 wrote:
    Hi,

    I have a doubt. Is there a DB session associated with every concurrent request or not. Because sometimes a request is running/pending but am not able to fetch associated session from the database. Please confirm !

    Thanks
    As long as the concurrent program needs to read/write from/to the database then will be a database session associated with it. If the concurrent program is done reading/writing and it is only formatting the output then you may not find a database version.

    Concurrent Processing - How to Find Database Session & Process Associated with a Concurrent Program Which is Currently Running. [ID 735119.1]

    Some concurrent programs which are used to accomplish tasks at the application level or the file system level (like host concurrent programs) will not have database sessions associated with it.

    Thanks,
    Hussein
  • 2. Re: Doubt on concurrent request
    986056 Newbie
    Currently Being Moderated
    Thanks much Hussein !

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points