Re: ps -ef |grep ora HELP!!

From: Scott Urman <surman_at_oracle.com>
Date: 1996/03/29
Message-ID: <4jhbac$igj_at_inet-nntp-gw-1.us.oracle.com>#1/1


In article <4jh77q$7c_at_nntpa.cb.att.com>, pandaris_at_jecsun.cb.att.com (Sridhar Pandari) writes:
|> We are running oracle 7.2.2 on HP/UX 10.01. When I grep for oracle processes
|> using ps -ef |grep ora command, I get the following:
|>
|> cs 916 846 0 21:45:51 ? 0:00 oracledcs8 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
|> cs 29362 1 0 21:40:19 ? 0:01 ora_smon_dcs8
|> slg 9613 9612 0 11:03:50 ? 0:00 oracledcs8 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
|> cs 937 868 0 21:45:52 ? 0:00 oracledcs8 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
|> cs 29344 1 0 21:40:17 ? 0:14 ora_lgwr_dcs8
|> cs 29259 1 0 21:40:13 ? 0:08 ora_pmon_dcs8
|> cs 29298 1 0 21:40:15 ? 0:23 ora_dbwr_dcs8
|>
|>
|> My question is, Why is it showing the (DESCRIPTION part? Moreover, what is
|> protocol beq? Never heard of it before.
|>
|> Can anyone help?
|>
|> Sridhar Pandari
|> --
|>
|>
|> \\/\\//
|> | O O |
These are Oracle shadow processes, started when a user process connects to the database. The DESCRIPTION means that these are connections using SQL*Net version 2, specificly the V2 bequeath adapter (the PROTOCOL part). This is the default adapter when you are connecting to a database on the same machine as your program. Try connecting with a connect string of 'p:' which will use the V1 pipe driver instead, and see what the process list says.

-- 
Scott Urman
"The opinions expressed here are my own, and are not necessarily that of
 Oracle Corporation"
Received on Fri Mar 29 1996 - 00:00:00 CET

Original text of this message