LoveUnix » ORACLE等数据库 » about semaphore of oracle
让LU留住您的每

一天 让LU博客留住您的每一天
2006-10-18 11:18 闲云
about semaphore of oracle

[size=12px][font=Verdana] [/font][indent][font=Verdana][size=2]quote:[/size][/font] There is a semaphore for every Oracle server process. Processes wait on their
semaphore when they need to wait for a resource, or need work to do, or need
work to be done. When the resource has been freed, or when there is work to do,
or when the prerequisite work has been done, then their semaphore is posted as a
signal to stop waiting. [/indent]

这是书上的一段话,在OS(AIX)层用ipcs,怎么没有看到属主为oracle的semaphore呢[/size]

2006-10-18 22:44 boypoo
数据库还没有启动吧

2006-10-18 22:49 boypoo
[oracle@RH4SRV1 ~]$ ipcs -s

------ Semaphore Arrays --------
key        semid      owner      perms      nsems     

[oracle@RH4SRV1 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Nov 5 22:57:39 2006

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.


SQL> startup
ORACLE instance started.

Total System Global Area  104857600 bytes
Fixed Size                  1217980 bytes
Variable Size              92277316 bytes
Database Buffers            8388608 bytes
Redo Buffers                2973696 bytes
Database mounted.
Database opened.
SQL> host ipcs -s

------ Semaphore Arrays --------
key        semid      owner      perms      nsems     
0xe5c0a82c 98304      oracle    640        104

2006-10-18 23:00 闲云
查了4个生产库,不可能没起来
只有一个hpux的oracle有看到

页: [1]
查看完整版本: about semaphore of oracle


Powered by Discuz! Archiver 5.5.0  © 2001-2006 Comsenz Inc.