Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

why oracle processes spawn too much

Printaporn_1
Esteemed Contributor

why oracle processes spawn too much

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,
enjoy any little thing in my life
3 REPLIES
Tom Geudens
Honored Contributor

Re: why oracle processes spawn too much

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
A life ? Cool ! Where can I download one of those from ?
Printaporn_1
Esteemed Contributor

Re: why oracle processes spawn too much

I fixed the problem by terminate one client program , but still not know what happen.
may be that client keep sending connection ???
enjoy any little thing in my life
Volker Borowski
Honored Contributor

Re: why oracle processes spawn too much

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