Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Regarding Oracle process  RSS feed

kannan vinayagam Duraiswamy
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?

form v$session table
228 183 1234 SERVER131 axadmin
229 219 1234 SERVER131 axadmin
230 532 1234 SERVER131 axadmin
231 217 1234 SERVER131 axadmin
219 13 1234 SERVER131 axadmin
247 296 1234 SERVER131 axadmin
242 200 1234 SERVER131 axadmin
233 105 1234 SERVER131 axadmin
234 342 1234 SERVER131 axadmin
235 259 1234 SERVER131 axadmin
236 520 1234 SERVER131 axadmin
257 20 1234 SERVER131 axadmin
248 105 4108@kannan5 SYS kannan.dv
232 126 4108@kannan5 SYS kannan.dv
269 1 554 oracle

  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!