why oracle processes spawn too much

[Printaporn_1]

Hi,

I get error file table full , after investigate I found that because of one of oracle process spawn a lot about 200+ when user session is only 20-40.
if I not wrong this is oracle server process , but why or how can I find out , it spawn too much.
in oracle v$process it is only 40+ , why I have more in OS ?

thanks in advance,

[Tom Geudens]

Hi,
I could be wrong here, but are you looking at the right parameters ? I would say you're running into either the "maxfiles" or the "nfile" parameter.

Hope this helps,
Tom Geudens

[Printaporn_1]

I fixed the problem by terminate one client program , but still not know what happen.
may be that client keep sending connection ???

[Volker Borowski]

Hello,

this is usally a problem of a misconfigured application. It is not waiting long enough if a connect is not successfull.

An attempt to connect leads to an oracle seesion/process being created. Now the connect fails, and it takes some time to remove the session. If during this period a new attempt to connect comes in, you might eat up oracle resourses faster than they are freed again.

This may esp. occur, if you fire some testtool to a webapplication, that creates a lot of new db-sessions at once.

Would be of interest, why the first connect did not succeed and initiated this loop. If this is just a single event, you might be fine to increase processes/session by ten, to give more spare resources for single peaks, but if it is the "testtool" situation, it might no be sufficiant.

Do not know if this helps.
Volker