Re: ORA-00020: maximum number of processes (%s) exceeded

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks Cowboy. Should I also make the connection = null;

Cowboy (Gregory A. Beamer) wrote:
Go through and call Dispose on connections when finished with them. Profile
the connections in Oracle and ensure they are being closed (I have seen
instances where this is not true and it is not good). You should also ensure
the connections are used for as short a time as possible.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think outside of the box!
*************************************************
"John G" <jwgiblin3@xxxxxxxxxxx> wrote in message
news:1158351673.592815.126750@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have been using the OleBDhelper
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/daab.asp)
with oracle. With a small group of people we recieved the following
message:
ORA-00020: maximum number of processes (%s) exceeded


Looking at some of the code in the OledbHelper, I noticed that there
was no close method on the connection. Can this be it. Also, I saw from
another user was they also set the connection to null so the garbage
collection would clean up that connection. thanks in advance.
Code:

public static DataSet ExecuteDataset(string connectionString,
CommandType commandType, string commandText, params OleDbParameter[]
commandParameters)
{
//create & open an OleDbConnection, and dispose of it after we are
done.
using (OleDbConnection cn = new OleDbConnection(connectionString))
{
cn.Open();

//call the overload that takes a connection in place of the
connection string
return ExecuteDataset(cn, commandType, commandText,
commandParameters);
}
}


.

Relevant Pages

  • Re: Objektdaten werden anderem User zugeordnet
    ... davon aus, dass "Shared" vorkam, oder? ... Public Shared Function ExecuteNonQuery(ByVal connection As SqlConnection, ByVal commandType As CommandType, ByVal commandText As String, ByVal ParamArray commandParameters As SqlParameter()) As Integer ...
    (microsoft.public.de.german.entwickler.dotnet.asp)
  • The OdbcCommand is currently busy Fetching
    ... Protected Overloads Overrides Function ExecuteReader(ByVal connection As ... ByVal commandType As CommandType, _ ... Dim cmd As New OdbcCommand ...
    (microsoft.public.data.odbc)
  • Re: Virtual SQL Server times out.
    ... Visual Studio.NET 2003 on a Windows 2003 Server machine and copied the ... Project from Visual Studioconnection is ... ByVal commandType As CommandType, _ ... > Online Partner Support Specialist ...
    (microsoft.public.sqlserver.clustering)
  • Re: Which is more efficient?
    ... Of the two, depending on your algorithm, you might see slightly higher performance with the reader, but it will be marginal. ... ByVal commandType As CommandType) As DataTable ... Using connection As New SqlConnection ... Dim table As New DataTable ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Which is more efficient?
    ... Public Function GetData(ByVal commandText As String, ByVal connectionString As String, ByVal commandType As CommandType) As DataTable ... Using connection As New SqlConnection ... Dim table As New DataTable ...
    (microsoft.public.dotnet.framework.aspnet)