2 Replies Latest reply: Feb 4, 2013 8:23 PM by 986056 RSS

    Doubt on concurrent request

    986056
      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
          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
            Thanks much Hussein !