| ORA-12520 when performing simultaneous requests [message #202318] |
Thu, 09 November 2006 01:57  |
eb1421
Messages: 3
Registered: November 2006
|
Junior Member |
|
|
Hello,
I am a complete Oracle beginner and I am working with Oracle 10g Express Edition.
My configuration is the one automatically set during installation.
I have 10 users sending a series of queries simultaneously (for benchmark purpose).
If I have 1 user, everything is OK.
When I have 10 users, for most of the queries I get the following error:
ORA-12520: TNS:listener could not find available handler for
requested type of server
I think it is a problem of number of simultaneous connections.
I have tried to :
- increase PROCESSED and PARALLEL_MAX_SERVERS in init.ora
- set QUEUE_SIZE in listener.ora
- set RECV_BUF_SIZE and SEND_BUF_SIZE in listener.ora and sqlnet.ora
...
and it does not help
Besides, the result of lsnrctl services seems OK.
Can someone help me with this problem ?
Thank you very much
Eve
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
