All pastes #584468 Raw Edit

resource pool conf

public shellscript v1 · immutable
·published 2007-06-22 19:46 UTC
rendered paste body
############# I HAVE 4 processors, i want all 4 to be in the oracle_pset############## ONLY CONFIGURING min 3 and max 4 works (or min 3 max 3 also works), see below:################bash-3.00# pooladm -xbash-3.00# rm /etc/pooladm.confbash-3.00# pooladm -sbash-3.00# poolcfg -c 'create pset ganesh_pset (uint pset.min=3; uint pset.max=4)'bash-3.00# poolcfg -c 'create pool oracle_pool'bash-3.00# poolcfg -c 'associate pool oracle_pool ( pset ganesh_pset )'bash-3.00# pooladm -cbash-3.00# pooladmsystem default        string  system.comment         int     system.version 1        boolean system.bind-default true        pool oracle_pool                int     pool.sys_id 4                boolean pool.active true                boolean pool.default false                int     pool.importance 1                string  pool.comment                 pset    ganesh_pset        pool pool_default                int     pool.sys_id 0                boolean pool.active true                boolean pool.default true                int     pool.importance 1                string  pool.comment                 pset    pset_default        pset ganesh_pset                int     pset.sys_id 1                boolean pset.default false                uint    pset.min 3                uint    pset.max 4                string  pset.units population                uint    pset.load 0                uint    pset.size 3                string  pset.comment                 cpu                        int     cpu.sys_id 1                        string  cpu.comment                         string  cpu.status on-line                cpu                        int     cpu.sys_id 0                        string  cpu.comment                         string  cpu.status on-line                cpu                        int     cpu.sys_id 2                        string  cpu.comment                         string  cpu.status on-line        pset pset_default                int     pset.sys_id -1                boolean pset.default true                uint    pset.min 1                uint    pset.max 65536                string  pset.units population                uint    pset.load 2                uint    pset.size 1                string  pset.comment                 cpu                        int     cpu.sys_id 3                        string  cpu.comment                         string  cpu.status on-line##################Now we try with min 4 max 4##################bash-3.00# pooladm -xbash-3.00# rm /etc/pooladm.confbash-3.00# pooladm -sbash-3.00# poolcfg -c 'create pset ganesh_pset (uint pset.min = 4; uint pset.max = 4)'bash-3.00# poolcfg -c 'create pool oracle_pool'bash-3.00# poolcfg -c 'associate pool oracle_pool ( pset ganesh_pset )'bash-3.00# pooladm -cpooladm: configuration at '/etc/pooladm.conf' cannot be instantiated on current system##### pooladm output: ######bash-3.00# pooladmsystem default        string  system.comment         int     system.version 1        boolean system.bind-default true        pool pool_default                int     pool.sys_id 0                boolean pool.active true                boolean pool.default true                int     pool.importance 1                string  pool.comment                 pset    pset_default        pset pset_default                int     pset.sys_id -1                boolean pset.default true                uint    pset.min 1                uint    pset.max 65536                string  pset.units population                uint    pset.load 3                uint    pset.size 4                string  pset.comment                 cpu                        int     cpu.sys_id 1                        string  cpu.comment                         string  cpu.status on-line                cpu                        int     cpu.sys_id 0                        string  cpu.comment                         string  cpu.status on-line                cpu                        int     cpu.sys_id 3                        string  cpu.comment                         string  cpu.status on-line                cpu                        int     cpu.sys_id 2                        string  cpu.comment                         string  cpu.status on-line