In our solaris server we use oracle database[oracle Thin client].
All our application process runs in that 'solaris' server.
we faced an issuse that there are so many oracle process shown in 'ps -aef|grep ora' command.
like from Augest there are 200 process still running!
and september around 122 process are running!
The process is like this
oracle 7175 1 0 17:12:47 ? 0:00 oracleSNM (LOCAL=NO)
The 'PROCESSES' parameter we set at oracle is 600.
when the "PROCESS" param reached around ~450 - some application process cant able to get the oracle connection!.
1.What that the (LOCAL=NO) indicates?
i searched the 'web' - what i found is "when the oracle is connected via an remote machine this kind of process is shown in the server" is the above one is correct ?
because our application process are running in the same machine as the oracle server runs.
i need some detailed or a clear info about the (LOCAL=NO)
2.when i checked the V$session table - some sessions are created with 'process' [client pid] column value as '1234'.
Then i check the server - what is the process that is running with that pid - but there is no such process with pid '1234'!.
Also for some other 'sessions' aslo has the the 'process' column is '1234' -
Also all this sessions are in INACTIVE state
what kind of process is this? why it's PID is not shown in the server?