bash oracle 进程中的 LOCAL=NO 是什么
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/21624058/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
What is LOCAL=NO in oracle processes
提问by Chaitanya
I was trying to find out processes that are consuming more memory on my Unix box using topcommand:
我试图使用以下top命令找出在我的 Unix 机器上消耗更多内存的进程：
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
23421 test 18 0 6408m 2.8g 2.8g D 0.0 23.7 1:03.63 xyz
11874 test 15 0 6378m 1.9g 1.9g S 0.0 16.1 0:05.47 xyz
31217 test 15 0 6379m 1.9g 1.9g R 0.0 16.0 0:44.21 xyz
As above processes are consuming more than 15% of MEMory, I tried to search further:
由于上述进程消耗了超过 15% 的 MEMory，我尝试进一步搜索：
-bash-3.2$ ps 23421 11874 31217
PID TTY STAT TIME COMMAND
23421 ? Ds 1:03 ora_dbw0_xyz
11874 ? Ss 0:05 oraclexyz (LOCAL=NO)
31217 ? Ds 0:46 oraclexyz (LOCAL=NO)
This command shows some output that Oracle database is consuming more memory. On searching in internet I found that ora_dbw0 is some database writer process but I am not able to understand what is (LOCAL=NO) process and how is it associated with Oracle database. Please help me in understanding what are these processes.
此命令显示 Oracle 数据库正在消耗更多内存的一些输出。在 Internet 上搜索时，我发现 ora_dbw0 是某个数据库编写器进程，但我无法理解什么是 (LOCAL=NO) 进程以及它与 Oracle 数据库有何关联。请帮助我理解这些过程是什么。
回答by Rob van Laarhoven
(LOCAL=NO) processes are the processes of connections using SQL*net (localhost or remote machines) and are not using MTS (Multi Threaded server)
(LOCAL=NO) 进程是使用 SQL*net（本地主机或远程机器）的连接进程，而不是使用 MTS（多线程服务器）
local processes, connections from the database server, using ORACLE_SID use the Bequeath protocol. In the process list these are show as : oracledxxx (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
本地进程，来自数据库服务器的连接，使用 ORACLE_SID 使用 Bequeath 协议。在进程列表中，这些显示为： oracledxxx (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
