La première chose à faire consiste à vérifier l'état de gestion des LargePage.
|
yah12 oracle@hayaor12:/home/oracle > ps -ef |grep pmon
oragi 13500552 1 0 Apr 11 - 1:45 asm_pmon_+ASM2
oracle 15925342 1 0 Apr 11 - 2:29 ora_pmon_yah22
oracle 19857546 1 0 Apr 15 - 1:45 ora_pmon_yah12
yah12 oracle@hayaor12:/home/oracle > svmon -P 15925342
-------------------------------------------------------------------------------
Pid Command Inuse Pin Pgsp Virtual 64-bit Mthrd 16MB
15925342 oracle 369934 291888 0 320564 Y N Y
PageSize Inuse Pin Pgsp Virtual
s 4 KB 58350 0 0 8980
m 64 KB 2834 1603 0 2834
L 16 MB 65 65 0 65
Vsid Esid Type Description PSize Inuse Pin Pgsp Virtual
a01220 70000005 work default shmat/mmap L 16 16 0 16
a61326 70000006 work default shmat/mmap L 16 16 0 16
c11241 70000004 work default shmat/mmap L 16 16 0 16
c51245 70000007 work default shmat/mmap L 15 15 0 15
2e09ae 10 clnt text data BSS heap, s 49318 0 - -
/dev/aap0_lv009:18429
990019 90000000 work shared library text m 1828 1088 0 1828
20002 0 work kernel segment m 566 512 0 566
e50a65 90000001 work shared library text m 435 0 0 435
30a83 70000008 work default shmat/mmap L 1 1 0 1
71387 70000000 work default shmat/mmap L 1 1 0 1
9b001b 90020014 work shared library s 2699 0 0 2699
50005 9ffffffd work shared library sm 2534 0 0 2534
9e121e 11 work text data BSS heap sm 1973 0 0 1973
e51265 80020014 work USLA heap sm 1573 0 0 1573
d01250 9001000a work shared library data sm 130 0 0 130
e41264 f00000002 work process private m 5 3 0 5
e000e 9ffffffe work shared library sm 42 0 0 42
6708e7 - clnt /dev/aap0_lv009:33392 s 23 0 - -
180198 9fffffff clnt USLA text,/dev/hd2:4191 s 18 0 - -
3112b1 ffffffff work application stack sm 15 0 0 15
1380 8fffffff work private load data s 11 0 0 11
c61046 - clnt /dev/aap0_lv008:24577 s 10 0 - -
d91259 8001000a work private load data sm 3 0 0 3
9e111e - clnt /dev/aap0_lv009:39034 s 1 0 - -
51385 70000001 mmap maps 1 source(s) sm 0 0 - -
cc104c - clnt /dev/aap0_lv008:24579 s 0 0 - -
|
Puis, dans de nombreux cas, il est préférable de retirer la gestion de LargePages par Oracle :
|
1. Vérification si LARGE PAGE :
SQL> show parameter lock_sga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean TRUE
SQL>Modifier la variable LOCK_SGA à FALSE.
ALTER SYSTEM SET LOCK_SGA=FALSE SCOPE=SPFILE sid='*';
2. Arrêter la base
3. Modification du .profile ORACLE : supprimer la variable : LDR_CNTRL
4. Positionner lgpg_regions=0
vmo -p -o lgpg_regions=0
5. Supprimer les “capabilities” sur le user oracle :
lsuser -a capabilities oracle
lsuser -a capabilities oragi
CAP_BYPASS_RAC_VMM,CAP_PROPOGATE oracle
chuser capabilities= oracle
chuser capabilities= oragi
6. Démarrer la base.
|
