ASP.NET Oracle 9.2.0.7 - Using ODP for .net - HANG Issue...

Discussion in 'ASP .Net' started by Nathan, Jan 5, 2006.

  1. Nathan

    Nathan Guest

    Hi

    We are having an application that uses ASP.Net / Oracle DB 9.2.0.7 /
    ODP for .net with connection pooling on

    We are using ODP .Net 9.2.0.4.01.

    We have set the parameters as below in the web.config file

    <add key="ERSDBConnectionString" value="Password=yyyy;User ID=zzzz;Data
    Source=xxxx;Persist Security Info=true;pooling=true;Min Pool Size=2;Max
    Pool Size=100;Incr Pool Size=2; Decr Pool Size=1;Connection
    Lifetime=1;Connection Timeout=2;"></add>

    We are using REF Cursors and XML Type datatypes in the Stored Procs

    We are linking to 5 other diff databases(4 Oracle and 1 SQL Server)

    Once our application hits the place where we are using xmltypes the
    application creates some sessions which dont get killed
    We tried all possible parameters and their values for Connection
    Pooling but no use

    Once we turn the conn pooling off, the application works fine for ever
    with out any hanging
    But is very slow

    Also by the time the application hangs we have accessed only the other
    Oracle databases and not the one single SQL Server database.

    Any pointers on how to solve this issue.

    We started with 9.2.01 then started applying all available pached of
    oracle and are in 9.2.0.7 now

    I would really appreciate any quick response.

    Regards
    Nathan
    Nathan, Jan 5, 2006
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?Sm9vc3QgRXZlcnRzZQ==?=

    ODP.NET : VB.NET and PLSQLAssociativeArray, hanging webserver

    =?Utf-8?B?Sm9vc3QgRXZlcnRzZQ==?=, Nov 5, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    2,287
    John Saunders
    Nov 6, 2004
  2. SK

    odp.net

    SK, Feb 14, 2005, in forum: ASP .Net
    Replies:
    2
    Views:
    690
    Scott Allen
    Feb 14, 2005
  3. venky

    Odp.net

    venky, Feb 15, 2005, in forum: ASP .Net
    Replies:
    0
    Views:
    891
    venky
    Feb 15, 2005
  4. =?Utf-8?B?RGlmZmlkZW50?=

    ODP.NET and Oracle 10g

    =?Utf-8?B?RGlmZmlkZW50?=, May 1, 2007, in forum: ASP .Net
    Replies:
    1
    Views:
    678
    Cowboy \(Gregory A. Beamer\)
    May 2, 2007
  5. Feyruz
    Replies:
    4
    Views:
    2,154
    Sherm Pendley
    Oct 14, 2005
Loading...

Share This Page