huhu
asked on
Runtime error 440 maximum 59 of processes exceeded
I am using oracle 8.1.7 (oo4o 8.1.7) and using VB6.0 to develop an application on window XP 2000. Every thing runs smoothly, but sometimes, there is an error stated that 'Runtime error 440 maximum 59 of processes exceeded' and all the connection to oracle are fail, I try to login oracle in work sheet the same error appears. I have to restart the application to run it again.
Can any one help me with this problem?
Thank a lot for your help
Huhu
Can any one help me with this problem?
Thank a lot for your help
Huhu
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Please tell me where is the v$parameter ?
It's a database view, you need to issue the SQL directly against the Oracle database using SQL*Plus or some other tool.
Here is a query you can use for v$parameter:
select value from v$parameter where name = 'processes';
or this one to see them all:
select substr(name,1,35) "Parameter",
substr(value,1,40) "Value"
from v$parameter;
That is just an alternate way of seeing basically the same things that you can see by opening the init*.ora file on the server.
select value from v$parameter where name = 'processes';
or this one to see them all:
select substr(name,1,35) "Parameter",
substr(value,1,40) "Value"
from v$parameter;
That is just an alternate way of seeing basically the same things that you can see by opening the init*.ora file on the server.
ASKER
Thank you all.
It sounds to me though like this is a client-side application error, since you are apparently able to get past it by restarting the application. If it was a database error, restarting the application would likely have no affect. I've never used VB so I can't help you with a VB error.