Application server hanging,Exeeding no of processes

[esreddy]

hi DBA gurus,
I got a problem.
I am connecting to the database through an Application server(JBOSS), but after a few minutes it is saying "STATUS IS ACTIVE, TIMED OUT" and Application server hanged.
Number of processes in INIT.ORA file are 300.
I querried from V$SESSION,

SELECT SID,USERNAME,STATUS FROM V$SESSION,

then it displayed only 113 connections.

Why the application server hanging, even i have given no of processes 300.

plz reply me asap.

thank you,
esreddy

[TimHall]

Is the error from Oracle "ORA-?????" or from the application server. It would be nice to know the actual error number and text.

If the error is from the application server it might be worth contacting your vendor to see if there is a parameter than limits the maximum number of simultaneous connections. It may not be anything to do with Oracle.

[esreddy]

hi
there is no ORA - Error. But is there ant relation between no. of processes and no. of connection?
thanks for ur reply

[TimHall]

If you are using Shared Server (Multi-Threaded Server) then the number of connections does not relate to the number of processes. If you are using dedicated server then every connection will spawn new processes.

If you're expecting hundreds of simultaneous connections you may be better server by using Shared Server.

If you are at all in doubt just increase the number of processes. If you still get the error at the same number of sessions then the problem is likely to be with your application server.

[esreddy]

i am using dedicated server, do u mean that each connection can serve for only one process? or it can serve for more than one process?
why i am asking this qn is my no.of connections are 113 and my database processes allowable are 300.can u explain in detail plz.
thanks
esreddy

[TimHall]

See links for details:

The PROCESSES parameter is used to set the maximum number of simultaneous user processes that can connect to Oracle. This includes background processes:

http://otn.oracle.com/docs/products/...1148.htm#38052

Since you're using dedicated server each user connection process will be assigned it's own server process. That makes two processes per connection. In some systems the two processes are combined into one.

http://otn.oracle.com/docs/products/...nproc.htm#9896
http://otn.oracle.com/docs/products/...intro.htm#3477

In your case I would consider using MTS. You can always specifiy dedicated connections if needed for specific jobs (See links above)

Cheers

[esreddy]

tahnks for the reply,
Do u mean that for each connection there will be a PMON,SMON........
How can i exactly know about how many processes are in use for a single connection?
Thanks
esreddy