セマフォ？ Tweet

Solaris11.3にOracle Database 12.1と12.2をなにげにインスコしてみたところ。。。

12.1.0.2はこんな感じ、processes=300なんで、Linuxでもよく見る感じでセマフォセット3 * セマフォ152（使われてないセマフォセットあり）

SQL> select * from v$version;

BANNER                                                                               CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production              0
PL/SQL Release 12.1.0.2.0 - Production                                                    0
CORE    12.1.0.2.0      Production                                                                0
TNS for Solaris: Version 12.1.0.2.0 - Production                                          0
NLSRTL Version 12.1.0.2.0 - Production                                                    0

SQL> 
SQL> show parameter processes

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     1
db_writer_processes                  integer     1
gcs_server_processes                 integer     0
global_txn_processes                 integer     1
job_queue_processes                  integer     1000
log_archive_max_processes            integer     4
processes                            integer     300
SQL> 

root@angelfish:˜#  cat /etc/release
                             Oracle Solaris 11.3 X86
  Copyright (c) 1983, 2015, Oracle and/or its affiliates.  All rights reserved.
                            Assembled 06 October 2015

root@angelfish:˜# ipcs -a
IPC status from  as of 2017年05月07日 (日) 17時58分27秒 JST
T         ID      KEY        MODE        OWNER    GROUP  CREATOR   CGROUP CBYTES  QNUM QBYTES LSPID LRPID   STIME    RTIME    CTIME 
Message Queues:
T         ID      KEY        MODE        OWNER    GROUP  CREATOR   CGROUP NATTCH      SEGSZ   CPID  LPID   ATIME    DTIME    CTIME 
Shared Memory:
m         28   0xc6002aac --rw-r-----   oracle oinstall   oracle oinstall     57      16384  1393  1671 17:57:45 17:58:02 17:47:36
m         27   0x0        --rw-r-----   oracle oinstall   oracle oinstall     57   14680064  1393  1671 17:57:45 17:58:02 17:47:36
m         26   0x0        --rw-r-----   oracle oinstall   oracle oinstall     57 2566914048  1393  1671 17:57:45 17:58:02 17:47:36
m         25   0x0        --rw-r-----   oracle oinstall   oracle oinstall     57    4194304  1393  1671 17:57:45 17:58:02 17:47:36
T         ID      KEY        MODE        OWNER    GROUP  CREATOR   CGROUP NSEMS   OTIME    CTIME 
Semaphores:
s          5   0xde1cdf8e --ra-r-----   oracle oinstall   oracle oinstall   152 17:47:39 17:47:36
s          4   0xde1cdf8d --ra-r-----   oracle oinstall   oracle oinstall   152 no-entry 17:47:36
s          3   0xde1cdf8c --ra-r-----   oracle oinstall   oracle oinstall   152 17:58:25 17:47:36
root@angelfish:˜# 

こちらは、12.2.0.1なんですが、セマフォないんですよ！　？？？？

Solarisつかうことも滅多にないんですが、気にはなりまする。なんだろう。なにかミスった？　ちなみに12.2＋Linuxだとしっかりセマフォが見えるんだけど。なにこれ。時間とれれば調べるか。。。も

SQL> select * from v$version;

BANNER                                                                               CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production              0
PL/SQL Release 12.2.0.1.0 - Production                                                    0
CORE    12.2.0.1.0      Production                                                                0
TNS for Solaris: Version 12.2.0.1.0 - Production                                          0
NLSRTL Version 12.2.0.1.0 - Production                                                    0

SQL> 
SQL> show parameter processes

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     1
asm_io_processes                     integer     20
db_writer_processes                  integer     1
gcs_server_processes                 integer     0
global_txn_processes                 integer     1
job_queue_processes                  integer     4000
log_archive_max_processes            integer     4
processes                            integer     300
SQL> 

root@angelfish:˜# ipcs -a
IPC status from  as of 2017年05月07日 (日) 18時15分51秒 JST
T         ID      KEY        MODE        OWNER    GROUP  CREATOR   CGROUP CBYTES  QNUM QBYTES LSPID LRPID   STIME    RTIME    CTIME 
Message Queues:
T         ID      KEY        MODE        OWNER    GROUP  CREATOR   CGROUP NATTCH      SEGSZ   CPID  LPID   ATIME    DTIME    CTIME 
Shared Memory:
m          8   0x60e9fb44 --rw-------   oracle oinstall   oracle oinstall     62      16384  1411  1463 18:15:01 18:15:15 18:11:48
m          7   0x0        --rw-------   oracle oinstall   oracle oinstall     62    8388608  1411  1463 18:15:01 18:15:15 18:11:48
m          6   0x0        --rw-------   oracle oinstall   oracle oinstall     62 2566914048  1411  1463 18:15:01 18:15:15 18:11:48
m          5   0x0        --rw-------   oracle oinstall   oracle oinstall     62   10485760  1411  1463 18:15:01 18:15:15 18:11:48
T         ID      KEY        MODE        OWNER    GROUP  CREATOR   CGROUP NSEMS   OTIME    CTIME 
Semaphores:
root@angelfish:˜# 

---

追記

bash-4.1$ pkg list entire
NAME (PUBLISHER)                                  VERSION                    IFO
entire                                            0.5.11-0.175.3.1.0.5.0     i--
bash-4.1$ uname -r
5.11
bash-4.1$ cat /etc/release
                             Oracle Solaris 11.3 X86
  Copyright (c) 1983, 2015, Oracle and/or its affiliates.  All rights reserved.
                            Assembled 06 October 2015
bash-4.1$ 
bash-4.1$ 
bash-4.1$ projects -l user.oracle
user.oracle
        projid : 101
        comment: ""
        users  : oracle
        groups : (none)
        attribs: process.max-sem-nsems=(privileged,256,deny)
                 project.max-sem-ids=(privileged,100,deny)
                 project.max-shm-ids=(privileged,100,deny)
                 project.max-shm-memory=(privileged,4294967296,deny)
bash-4.1$