<12/26> 성능고도화 Rac11g

10g expert asm 관리 챕터 체크

select component, current_size, min_size, max_size

from v$memory_dynamic_components

where current_size <> 0;

COMPONENT                      CURRENT_SIZE   MIN_SIZE   MAX_SIZE

------------------------------ ------------ ---------- ----------

shared pool                       171966464  104857600  171966464

large pool                          8388608    8388608   71303168

java pool                           4194304    4194304    4194304

SGA Target                        629145600  629145600  629145600

DEFAULT buffer cache              432013312  369098752  432013312

PGA Target                        209715200  209715200  209715200

elect name, description

from v$bgprocess

where paddr <> '00'

NAME  DESCRIPTION

----- ----------------------------------------------------------------

PMON  process cleanup

VKTM  Virtual Keeper of TiMe process

GEN0  generic0

DIAG  diagnosibility process

DBRM  DataBase Resource Manager

RSMN  Remote Slave Monitor

PING  interconnect latency measurement

PSP0  process spawner 0

ACMS  Atomic Controlfile to Memory Server

DIA0  diagnosibility process 0

LMON  global enqueue service monitor

LMD0  global enqueue service daemon 0

LMS0  global cache service process 0

RMS0  rac management server

LMHB  lm heartbeat monitor

MMAN  Memory Manager

DBW0  db writer process 0

ARC0  Archival Process 0

ARC1  Archival Process 1

ARC2  Archival Process 2

ARC3  Archival Process 3

LGWR  Redo etc.

LCK0  Lock Process 0

CKPT  checkpoint

SMON  System Monitor Process

SMCO  Space Manager Process

RECO  distributed recovery

GTX0  Global Txn process 0

CJQ0  Job Queue Coordinator

RCBG  Result Cache: Background

QMNC  AQ Coordinator

RBAL  ASM Rebalance master

ASMB  ASM Background

MARK  mark AU for resync koordinator

MMON  Manageability Monitor Process

MMNL  Manageability Monitor Process 2

ASMCMD> ls -l

Type              Redund  Striped  Time             Sys  Name

ASMPARAMETERFILE  UNPROT  COARSE   DEC 15 16:00:00  Y    REGISTRY.253.898533177

select redundancy, stripe, name, primary_region,mirror_region

from v$asm_template

where group_number = 3

REDUND STRIPE NAME                           PRIM MIRR

------ ------ ------------------------------ ---- ----

UNPROT COARSE PARAMETERFILE                  COLD COLD

UNPROT COARSE ASMPARAMETERFILE               COLD COLD

UNPROT COARSE DUMPSET                        COLD COLD

UNPROT FINE   CONTROLFILE                    COLD COLD

UNPROT COARSE FLASHFILE                      COLD COLD

UNPROT COARSE ARCHIVELOG                     COLD COLD

UNPROT COARSE ONLINELOG                      COLD COLD

UNPROT COARSE DATAFILE                       COLD COLD

UNPROT COARSE TEMPFILE                       COLD COLD

UNPROT COARSE BACKUPSET                      COLD COLD

UNPROT COARSE XTRANSPORT BACKUPSET           COLD COLD

UNPROT COARSE AUTOBACKUP                     COLD COLD

UNPROT COARSE XTRANSPORT                     COLD COLD

UNPROT COARSE CHANGETRACKING                 COLD COLD

UNPROT COARSE FLASHBACK                      COLD COLD

UNPROT COARSE DATAGUARDCONFIG                COLD COLD

UNPROT COARSE OCRFILE                        COLD COLD