Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    5

    Unanswered: RPC call leaves sessions open in the Remote end.

    I have a distributed database application.
    A RPC call leaves connections open on the remote end.
    The RPC call is done via a application running at the host machine.
    Though the response is received pretty quickly the connections remain open.
    After some time the application hangs as more connections to the remote database is not possible.

    Any particular reason as to why this may happen?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You are NOT closing the remote connection(s).
    ALTER SESSION CLOSE DATABASE LINK <REMOTE>;

  3. #3
    Join Date
    Sep 2003
    Posts
    5
    Originally posted by anacedent
    You are NOT closing the remote connection(s).
    ALTER SESSION CLOSE DATABASE LINK <REMOTE>;
    Actually I wud not want to close the DB link. The overlying application is a multithreaded one and more than one RPC call can happen.

    If I close and open the connection every time, will it not affect the performance?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    1) What OS & OS version for all systems involved?
    2) What versions of all Oracle DBs involved?

    >After some time the application hangs as more connections to the remote database is not possible.
    If application does "hang", what evidence do you have that it is due to having too many open connections?
    Why doesn't "application" error out rather than "hang"?
    >If I close and open the connection every time, will it not affect the performance?
    It sounds to me that you already have "performance problems".
    Which is better, slow & working or broken & not working?
    What does "RPC" mean? (Remote Procedure Call?)
    If so, exactly how does the remote database invoke the RCP?
    Has this ever worked reliably?

  5. #5
    Join Date
    Sep 2003
    Posts
    5
    Well both the Dbs are 8is.
    Operating system Unix on Solaris. I will get back with more details later.

    Well the application, a provisioning system, basically performs lots of other non database activities.
    Sometimes data from external systems have to be accessed, We use PRo*C to make these oracle calls.
    By RPC I mean ........ package.procedure@remotedatabase();

    It used to work fine before, however , there has been a lot of traffic coming thru to the systems and a lots of call are being made at a particular time.

Posting Permissions

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