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]
Powered by Discuz! Archiver 5.5.0
© 2001-2006 Comsenz Inc.