Unknown Oracle processes [message #55418] |
Thu, 23 January 2003 09:46 |
Marks
Messages: 11 Registered: February 2002
|
Junior Member |
|
|
I have a number of Oracle processes on my production box that seem to use CPU time but I don't what they are. When I use glance performance monitor I can see that they are holding many database files open, including the control files. I've tried to associate them with events in the database alert log but I've had no luck. Their parent is always pid 1, which I imagine means that they've been started by the init process. I've also tried to find their pid in the database v$ views with no luck.
Are they an Oracle background job like pmon or some kind of disconnected shadow process ?
Can anyone shed any light on what they may be or how I can trace them in the database views?
Below is the output from a 'ps' command.
orar3p 17621 1 0 08:16:10 ? 1:23 oracleR3P (DESCRIPTION=(LOCAL=NO)(SDU=32768))
|
|
|
|
Re: Unknown Oracle processes [message #55444 is a reply to message #55418] |
Fri, 24 January 2003 06:42 |
Marks
Messages: 11 Registered: February 2002
|
Junior Member |
|
|
Thanks for the info - it is good starting point.
It seems that to trace an OS pid number I look at v$process (spid), then use addr to relate back to the
v$session view.
If a row from v$process has no related records in v$session, does this mean that the OS process has disconnected in some way from Oracle ?
If a row in v$session is INACTIVE does this mean its just sleeping or its dead?
Am I right in thinking that v$session.sql_address is used to join with v$sqltext.address?
|
|
|