aspose file tools*
The moose likes Oracle/OAS and the fly likes Regarding Oracle process Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Regarding Oracle process" Watch "Regarding Oracle process" New topic
Author

Regarding Oracle process

kannan vinayagam Duraiswamy
Ranch Hand

Joined: Jan 12, 2009
Posts: 52
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!.

Questions:
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
SID SERIAL# PROCESS USERNAME OSUSER
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



Kannan.DV
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Regarding Oracle process
 
Similar Threads
JDBC and SQL Server 2000 Part II Question
Tomcat 6.0.20 - session expiration not happening while machine is loaded
how to get Clients CPU information on Server using Java RMI
The mode flag
how to kill a process(I know the port in which it runs)