Server processes not exiting out
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Server processes not exiting out

  1. #1
    Join Date
    Apr 2003
    Posts
    3

    Question Server processes not exiting out

    Hi,

    Environment:

    Oracle 9.1.2 on Windows XP
    Shared Server Mode
    Web application developed in VB.NET
    Uses OracleClient from Microsoft (ADO.NET)
    Stored Proc in Oracle returns REF CURSOR.

    Problem:

    Whenever the VB code executes the stored procedure GetData (to return rows) a new server process is initiated. However this process does not exit even after closing the connection. As a result, the number of processes keep on growing and soon exceed the MAX_PROCESSES limit.

    Please advise on the action needed.

    Thanks a lot.

    VC

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    sort out your application to actually close the connection

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Ur application code has bugs or not properly coded to close the connection.

    As far as with VB is conserned...
    We do define ojbect to adodb conn type.

    Object.open
    app logic
    object.close

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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