ORA-12520: TNS:listener could not find available handler for requested type
556560Feb 12 2007 — edited May 9 2007Hello,
I'm trying to run some load tests my application's framework. I've created a Unit Test that inserts, selects and deletes 1000 records. Everything works perfectly until I try and increase the workload to 2000 records.
When I try to increase to 2000, I start getting "ORA-12520: TNS:listener could not find available handler for requested type of server" around 1600 in the loop. The point in the loop at which it starts failing isn't consistant, but it always occurs when trying to open the connection:
myOracleConnection.Open();
Have I just hit a limitation of ODP.NET or of Oracle 10g Express? Does anyone know of any settings I could change to improve Oracle's performance? I'd really appreciate some help,
Mycole
Btw, I made sure I'm calling Dispose() on my OracleDataReader, OracleConnection and OracleCommand.