Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2008

    Post Unanswered: Regarding Concurrent Connections


    GoodDay, This is Ramesh. I am working as a PL/SQL developer.

    I have created one procedure to retrieve the data from Client DB to our local DB. For that we used DBLink. My procedure contains 7 cursors. Here the question is, how many concurrent connections would be needed to ORACLE to execute this procedure.

    Replies are very helpful for me..

    Thnaks in Advance,

  2. #2
    Join Date
    Aug 2008
    If it is a batch process then you probably need one connection, BUT you can leverage the parallel processing in this case.

  3. #3
    Join Date
    Sep 2008
    Actually we have one DBLink connection to retrieve the Data From Client DB.

  4. #4
    Join Date
    Sep 2002
    I believe you might be confused about what a DBLInk actually is. It is not dynamic in that it is always connected. It is more like the definition of a connection and is only active when a process needs it. If multiple processes need it, then there will be multiple connections from the source database to the target database.

    So, even though you have only defined it once, it can be used multiple times concurrently.

Posting Permissions

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