OraFAQ Forum: Server Administration » Unknown Oracle processes

Home » RDBMS Server » Server Administration » Unknown Oracle processes

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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))

Report message to a moderator

Re: Unknown Oracle processes [message #55419 is a reply to message #55418]

Thu, 23 January 2003 10:26

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

usually
(DESCRIPTION=(LOCAL=NO) might be process ( created by connections or subprocess without using a connect_string).
if you see a
(DESCRIPTION=(LOCAL=YES) it is a process ( created by
a connection using connect_string).
and
[b]
this process is baseprocess oracle< sid > run by oracle[/b]
 oracle 13019     1  0 10:43:59 ?         0:00 oracleprod (LOCAL=NO)
[b]this shows this is related to oracle_< background_process >_< sid >[/b]
oracle 25296     1  0  Jan 17  ?         3:05 ora_ckpt_prod
oracle 25298     1  0  Jan 17  ?         0:37 ora_smon_prod
[b]this shows a client or application (lawson) is accesing database using connect_string.[/b]
 lawson 14283 14280  0 11:24:37 ?         0:00 oracleprod (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

  1* select sid,serial#,username,osuser,status,type,program,machine from v$session
tricore@prod_world> /

SID    SERIAL# USERNAME   OSUSER   STATUS   TYPE       PROGRAM                   MACHINE
--- ---------- ---------- -------- -------- ---------- ------------------------- -------------------
  1          1            oracle   ACTIVE   BACKGROUND oracle@larch (PMON)       larch
  2          1            oracle   ACTIVE   BACKGROUND oracle@larch (DBW0)       larch
  3          1            oracle   ACTIVE   BACKGROUND oracle@larch (ARCH)       larch
  4          1            oracle   ACTIVE   BACKGROUND oracle@larch (LGWR)       larch
  5          1            oracle   ACTIVE   BACKGROUND oracle@larch (CKPT)       larch
  6          1            oracle   ACTIVE   BACKGROUND oracle@larch (SMON)       larch
  7          1            oracle   ACTIVE   BACKGROUND oracle@larch (RECO)       larch
 10        648 GENOME     Bauer    INACTIVE USER                                 CHARLESPC14020
 11        730 GENOME     Bauer    INACTIVE USER                                 CHARLESPC14020
 13       1241 LAWSON     lawson   INACTIVE USER          ?  @larch (TNS V1-V3)  larch
 15       1443 GENOME     Bauer    INACTIVE USER                                 CHARLESPC14020
 17        484 LAWSON     lawson   INACTIVE USER          ?  @larch (TNS V1-V3)  larch
 20          3 TRICORE    magvivek ACTIVE   USER       SQLPLUSW.EXE              WORKGROUPITLOANER1

Report message to a moderator

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?

Report message to a moderator

Previous Topic:	oracle 8.1.7 installation and configuration on redhat linux7.3
Next Topic:	Successfully processed row count.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:41:42 CDT 2024