LOCAL=NO Process owner id

[KapilRaj]

Guys,

Nice to see u all after a long time. I am little busy these days.

I have a database node here which runs a production database. Oracle7 Server Release 7.3.4.0.0

To me , the processes like "(LOCAL=NO)" or "(LOCAL=YES)" are the database processes which is responsible for user connections and their queries / commands.

Most of these processes are owned by the oracle owner id "oracle". But some of them , are not. I found "LOCAL=YES PROTOCOL=beq" processes are owned by the user who initiated the sqlplus command.

Is this normal ?. Is there anything to worry about ?.

Regds,

Kaps

[Sridhar Bhaskarla · Accepted solution]

Hi Kapil,

Yes. All the remote connections will be shown with LOCAL=NO with oracle as the owner as the connections will be spawned by oracle user. For the local connections, the processes will be owned by the users that ran the sqlplus command.

-Sri

[KapilRaj]

Thank you Sridhar,

I am not closing the thread as i need to get some more info about this tns , beq and expecting some more expert opinions.

Regds,

Kaps

[Sridhar Bhaskarla]

Kaps,

Try this document meanwhile. I look at this whenever I get doubts on my DBA's explanations. This may be for 8i but concepts are explained well.

http://oracledoc.wccnet.org/oracle8i/solaris.815/a67456/ch5.htm#26799

-Sri

[Indira Aramandla]

Hi Kapil,

The 'Bequeath' protocol adapter is the default Net driver on Oracle7 and Oracle8 releases on UNIX. It has two main purposes:

a) To 'spawn' subprocesses and pass / receive message(s) to / from the spawned process.
b) To provide a default local SQL*Net connection layerthat does NOT require any listener process.

The processes you have are subprocesses spawned by the bequeath protocol adapter. Some would be owner by oracle and the others will be owned by the user which initiated sqlplus with OS authentication.

Local processes are the bequeathed connections, i.e connections made to the database through the local server machine without listener interference.

The attached document from metalink explains beq adapter and how it spawns subprocesses and so on


Indira A

[KapilRaj]

Now the real problem ... when dba's create a database they ask me(sysad) to set the ulimit values for data size etc ... now these will need to be set for the individual user'ids as well who uses beq ?

Kaps

[Yogeeraj_1]

hi kaps,

for your last question, you may wish to add the the ulimit command in the .profile of the users.

see also:
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=233595
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=41740
and
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=49882

hope this helps!

regards
Yogeeraj

[Jean-Luc Oudart]

Hi Kaps,

For non local users, the connections will run through SQL*NET / NET8 and spawn process with tns process owner. If the (specific) listener is not started by oracle you will find processes owned by this different users.
This can be usefull when you run different listeners and you want to distinguish them.

for more on IPC and BEQ protocol see Metalink notes :
Note: 29232.1 - IPC Explained
Note: 16653.1 - (2) The Bequeath Protocol Adapter

Once, I measured a BEQ vs a non local connection. The later was using more system resources.

Regards,
Jean-Luc

[Hein van den Heuvel]

If you do not want to adapt the users resources to the Oracle needs, then you'll need to make them go through the listener by connecting @SID-IN-TNS-NAMES instead of just using $ORACLE_SID for the local instance.

As Jean Luc indicates, this will use a little more resources. How much more? Your milage will vary, but since the overhead is strictly in the message passing, is seems ovbious that it will be more noticeable for application with many quick sql queries (singleton selects/inserts) versus applications executig complex joins/bulk updates.

If you do go the listener/tnsnames route, then our experience you want to use IPC for locak connects, not a network stack.

fwiw.
Hein.

[KapilRaj]

Thank you all

Kaps