Exadata의 cellserver는 기존의 disk server와 개념과 구조가 많이 달라
기본적으로 사용하고 있는 system 모니터링 툴의 기능 만으로 전반적인 내용을 판단하기 어렵습니다.
Oracle Enterprise Manager를 사용해보신 분은 알겠지만..
오라클은 matric에 대한 임계치를 설정해 그에 따른 경고를 보내 주는 기능을 조아합니다.
가장 많이 사용한 EM의 matric은 active session 등이 특정 개수 이상일 경우 경고해주는 등이죠..
Exadata의 cellserver도 그 와 비슷하게 여러 matric을 만들어 놓고 이에 따른 임계치를 설정할 수 있습니다.
이 임계치 설정에 따라 미리 설정된 sms나 메일로 경고를 받아 볼 수 있습니다.
아래 리스트는 Exadata cellserver에서 설정할 수 있는 전체 matric 입니다.
대부분 성능에 대한 matric이나 file system 사용량이나 CPU 사용량, IO error 에 대한 임계치를 미리 설정할 만 하네요.
CellCLI> list METRICDEFINITION attributes name, description
CD_IO_BY_R_LG "Number of megabytes read in large blocks from a
cell disk"
CD_IO_BY_R_LG_SEC "Number of megabytes read
in large blocks per second from a cell disk"
CD_IO_BY_R_SM "Number of megabytes read in small blocks from a
cell disk"
CD_IO_BY_R_SM_SEC "Number of megabytes read
in small blocks per second from a cell disk"
CD_IO_BY_W_LG "Number of megabytes written in large blocks to
a cell disk"
CD_IO_BY_W_LG_SEC "Number of megabytes
written in large blocks per second to a cell disk"
CD_IO_BY_W_SM "Number of megabytes written in small blocks to
a cell disk"
CD_IO_BY_W_SM_SEC "Number of megabytes
written in small blocks per second to a cell disk"
CD_IO_ERRS "Number of IO errors on a cell disk"
CD_IO_ERRS_MIN "Number of IO errors on a cell disk per
minute"
CD_IO_RQ_R_LG "Number of requests to read
large blocks from a cell disk"
CD_IO_RQ_R_LG_SEC
"Number of requests to read large blocks per second from a cell
disk"
CD_IO_RQ_R_SM "Number of requests to read
small blocks from a cell disk"
CD_IO_RQ_R_SM_SEC
"Number of requests to read small blocks per second from a cell
disk"
CD_IO_RQ_W_LG "Number of requests to write
large blocks to a cell disk"
CD_IO_RQ_W_LG_SEC "Number
of requests to write large blocks per second to a cell disk"
CD_IO_RQ_W_SM "Number of requests to write small blocks to a
cell disk"
CD_IO_RQ_W_SM_SEC "Number of requests to
write small blocks per second to a cell disk"
CD_IO_ST_RQ "Average service time per request for small IO
requests to a cell disk"
CD_IO_TM_R_LG "Cumulative
latency of reading large blocks from a cell disk"
CD_IO_TM_R_LG_RQ "Average latency of writing large blocks per
request to a cell disk"
CD_IO_TM_R_SM "Cumulative
latency of reading small blocks from a cell disk"
CD_IO_TM_R_SM_RQ "Average latency of reading small blocks per
request from a cell disk"
CD_IO_TM_W_LG
"Cumulative latency of writing large blocks to a cell disk"
CD_IO_TM_W_LG_RQ "Average latency of writing large blocks per
request to a cell disk"
CD_IO_TM_W_SM "Cumulative
latency of writing small blocks to a cell disk"
CD_IO_TM_W_SM_RQ "Average latency of writing small blocks per
request to a cell disk"
CG_FC_IO_BY_SEC "Number of
megabytes of I/O per second for this consumer group to flash cache"
CG_FC_IO_RQ "Number of IO requests issued by a consumer
group to flash cache"
CG_FC_IO_RQ_SEC "Number of IO
requests issued by a consumer group to flash cache per second"
CG_FD_IO_BY_SEC "Number of megabytes of I/O per second for this
consumer group to flash disks"
CG_FD_IO_LOAD
"Average I/O load from this consumer group for flash disks"
CG_FD_IO_RQ_LG "Number of large IO requests issued by a
consumer group to flash disks"
CG_FD_IO_RQ_LG_SEC
"Number of large IO requests issued by a consumer group to flash disks per
second"
CG_FD_IO_RQ_SM "Number of small IO requests
issued by a consumer group to flash disks"
CG_FD_IO_RQ_SM_SEC "Number of small IO requests issued by a
consumer group to flash disks per second"
CG_IO_BY_SEC "Number of megabytes of I/O per second for this
consumer group to hard disks"
CG_IO_LOAD
"Average I/O load from this consumer group for hard disks"
CG_IO_RQ_LG "Number of large IO requests issued by a
consumer group to hard disks"
CG_IO_RQ_LG_SEC
"Number of large IO requests issued by a consumer group to hard disks per
second"
CG_IO_RQ_SM "Number of small IO requests
issued by a consumer group to hard disks"
CG_IO_RQ_SM_SEC "Number of small IO requests issued by a
consumer group to hard disks per second"
CG_IO_UTIL_LG "Percentage of disk resources utilized by large
requests from this consumer group"
CG_IO_UTIL_SM
"Percentage of disk resources utilized by small requests from this consumer
group"
CG_IO_WT_LG "IORM wait time for large IO
requests issued by a consumer group"
CG_IO_WT_LG_RQ
"Average IORM wait time per request for large IO requests issued by a consumer
group"
CG_IO_WT_SM "IORM wait time for small IO
requests issued by a consumer group"
CG_IO_WT_SM_RQ
"Average IORM wait time per request for small IO requests issued by a consumer
group"
CL_CPUT "Cell CPU Utilization is the
percentage of time over the previous minute that the system CPUs were not idle
(from /proc/stat)."
CL_FANS "Number of
working fans on the cell"
CL_FSUT
"Percentage of total space on this file system that is currently
used"
CL_MEMUT "Percentage of total physical
memory on the cell that is currently used"
CL_RUNQ "Average number (over the preceding minute) of
processes in the Linux run queue marked running or uninterruptible (from
/proc/loadavg)."
CL_TEMP "Temperature
(Celsius) of the server, provided by the BMC"
CT_FC_IO_BY_SEC "Number of megabytes of I/O per second for this
category to flash cache"
CT_FC_IO_RQ "Number of
IO requests issued by an IORM category to flash cache"
CT_FC_IO_RQ_SEC "Number of IO requests issued by an IORM
category to flash cache per second"
CT_FD_IO_BY_SEC
"Number of megabytes of I/O per second for this category to flash
disks"
CT_FD_IO_LOAD "Average I/O load from this
category for flash disks"
CT_FD_IO_RQ_LG "Number of
large IO requests issued by an IORM category to flash disks"
CT_FD_IO_RQ_LG_SEC "Number of large IO requests issued by an IORM
category to flash disks per second"
CT_FD_IO_RQ_SM
"Number of small IO requests issued by an IORM category to flash
disks"
CT_FD_IO_RQ_SM_SEC "Number of small IO requests
issued by an IORM category to flash disks per second"
CT_IO_BY_SEC "Number of megabytes of I/O per second for this
category to hard disks"
CT_IO_LOAD "Average I/O
load from this category for hard disks"
CT_IO_RQ_LG "Number of large IO requests issued by an IORM
category to hard disks"
CT_IO_RQ_LG_SEC "Number of
large IO requests issued by an IORM category to hard disks per
second"
CT_IO_RQ_SM "Number of small IO requests
issued by an IORM category to hard disks"
CT_IO_RQ_SM_SEC "Number of small IO requests issued by an IORM
category to hard disks per second"
CT_IO_UTIL_LG
"Percentage of disk resources utilized by large requests from this
category"
CT_IO_UTIL_SM "Percentage of disk
resources utilized by small requests from this category"
CT_IO_WT_LG "IORM wait time for large IO requests issued by
an IORM category"
CT_IO_WT_LG_RQ "Average IORM wait
time per request for large IO requests issued by an IORM category"
CT_IO_WT_SM "IORM wait time for small IO requests issued by
an IORM category"
CT_IO_WT_SM_RQ "Average IORM wait
time per request for small IO requests issued by an IORM category"
DB_FC_IO_BY_SEC "Number of megabytes of I/O per second for this
database to flash cache"
DB_FC_IO_RQ "Number of
IO requests issued by a database to flash cache"
DB_FC_IO_RQ_SEC "Number of IO requests issued by a database to
flash cache per second"
DB_FD_IO_BY_SEC "Number of
megabytes of I/O per second for this database to flash disks"
DB_FD_IO_LOAD "Average I/O load from this database for flash
disks"
DB_FD_IO_RQ_LG "Number of large IO requests
issued by a database to flash disks"
DB_FD_IO_RQ_LG_SEC
"Number of large IO requests issued by a database to flash disks per
second"
DB_FD_IO_RQ_SM "Number of small IO requests
issued by a database to flash disks"
DB_FD_IO_RQ_SM_SEC
"Number of small IO requests issued by a database to flash disks per
second"
DB_IO_BY_SEC "Number of megabytes of I/O
per second for this database to hard disks"
DB_IO_LOAD "Average I/O load from this database for hard
disks"
DB_IO_RQ_LG "Number of large IO requests
issued by a database to hard disks"
DB_IO_RQ_LG_SEC
"Number of large IO requests issued by a database to hard disks per
second"
DB_IO_RQ_SM "Number of small IO requests
issued by a database to hard disks"
DB_IO_RQ_SM_SEC
"Number of small IO requests issued by a database to hard disks per
second"
DB_IO_UTIL_LG "Percentage of disk
resources utilized by large requests from this database"
DB_IO_UTIL_SM "Percentage of disk resources utilized by small
requests from this database"
DB_IO_WT_LG "IORM
wait time for large IO requests issued by a database"
DB_IO_WT_LG_RQ "Average IORM wait time per request for large IO
requests issued by a database"
DB_IO_WT_SM "IORM
wait time for small IO requests issued by a database"
DB_IO_WT_SM_RQ "Average IORM wait time per request for small IO
requests issued by a database"
FC_BYKEEP_OVERWR
"Number of megabytes pushed out of the FlashCache because of space limit for
'keep' objects"
FC_BYKEEP_OVERWR_SEC "Number of megabytes
per second pushed out of the FlashCache because of space limit for 'keep'
objects"
FC_BYKEEP_USED "Number of megabytes used
for 'keep' objects on FlashCache"
FC_BY_USED
"Number of megabytes used on FlashCache"
FC_IO_BYKEEP_R "Number of megabytes read from FlashCache for
'keep' objects"
FC_IO_BYKEEP_R_SEC "Number of megabytes
read per second from FlashCache for 'keep' objects"
FC_IO_BYKEEP_W "Number of megabytes written to FlashCache for
'keep' objects"
FC_IO_BYKEEP_W_SEC "Number of megabytes
per second written to FlashCache for 'keep' objects"
FC_IO_BY_R "Number of megabytes read from
FlashCache"
FC_IO_BY_R_MISS "Number of megabytes
read from disks because not all requested data was in FlashCache"
FC_IO_BY_R_MISS_SEC "Number of megabytes read from disks per second
because not all requested data was in FlashCache"
FC_IO_BY_R_SEC "Number of megabytes read per second from
FlashCache"
FC_IO_BY_R_SKIP "Number of megabytes
read from disks for IO requests with a hint to bypass FlashCache"
FC_IO_BY_R_SKIP_SEC "Number of megabytes read from disks per second
for IO requests with a hint to bypass FlashCache"
FC_IO_BY_W "Number of megabytes written to
FlashCache"
FC_IO_BY_W_SEC "Number of megabytes per
second written to FlashCache"
FC_IO_ERRS
"Number of IO errors on FlashCache"
FC_IO_RQKEEP_R
"Number of read IO requests for 'keep' objects satisfied from
FlashCache"
FC_IO_RQKEEP_R_MISS "Number of read IO
requests for 'keep' objects which did not find all data in
FlashCache"
FC_IO_RQKEEP_R_MISS_SEC "Number of read IO
requests per second for 'keep' objects which did not find all data in
FlashCache"
FC_IO_RQKEEP_R_SEC "Number of read IO
requests for 'keep' objects per second satisfied from FlashCache"
FC_IO_RQKEEP_R_SKIP "Number of read IO requests for 'keep' objects
with a hint to bypass FlashCache"
FC_IO_RQKEEP_R_SKIP_SEC
"Number of read IO requests per second for 'keep' objects with a hint to bypass
FlashCache"
FC_IO_RQKEEP_W "Number of IO requests
for 'keep' objects which resulted in FlashCache being populated with
data"
FC_IO_RQKEEP_W_SEC "Number of IO requests per
second for 'keep' objects which resulted in FlashCache being populated with
data"
FC_IO_RQ_R "Number of read IO requests
satisfied from FlashCache"
FC_IO_RQ_R_MISS "Number
of read IO requests which did not find all data in FlashCache"
FC_IO_RQ_R_MISS_SEC "Number of read IO requests per second which did
not find all data in FlashCache"
FC_IO_RQ_R_SEC
"Number of read IO requests satisfied per second from FlashCache"
FC_IO_RQ_R_SKIP "Number of read IO requests with a hint to
bypass FlashCache"
FC_IO_RQ_R_SKIP_SEC "Number of read
IO requests per second with a hint to bypass FlashCache"
FC_IO_RQ_W "Number of IO requests which resulted in
FlashCache being populated with data"
FC_IO_RQ_W_SEC "Number of IO requests per second which resulted
in FlashCache being populated with data"
FD_IO_LOAD "Average I/O load for flash disks"
GD_IO_BY_R_LG "Number of megabytes read in large blocks from a
grid disk"
GD_IO_BY_R_LG_SEC "Number of megabytes read
in large blocks per second from a grid disk"
GD_IO_BY_R_SM "Number of megabytes read in small blocks from a
grid disk"
GD_IO_BY_R_SM_SEC "Number of megabytes read
in small blocks per second from a grid disk"
GD_IO_BY_W_LG "Number of megabytes written in large blocks to
a grid disk"
GD_IO_BY_W_LG_SEC "Number of megabytes
written in large blocks per second to a grid disk"
GD_IO_BY_W_SM "Number of megabytes written in small blocks to
a grid disk"
GD_IO_BY_W_SM_SEC "Number of megabytes
written in small blocks per second to a grid disk"
GD_IO_ERRS "Number of IO errors on a grid disk"
GD_IO_ERRS_MIN "Number of IO errors on a grid disk per
minute"
GD_IO_RQ_R_LG "Number of requests to read
large blocks from a grid disk"
GD_IO_RQ_R_LG_SEC
"Number of requests to read large blocks per second from a grid
disk"
GD_IO_RQ_R_SM "Number of requests to read
small blocks from a grid disk"
GD_IO_RQ_R_SM_SEC
"Number of requests to read small blocks per second from a grid
disk"
GD_IO_RQ_W_LG "Number of requests to write
large blocks to a grid disk"
GD_IO_RQ_W_LG_SEC "Number
of requests to write large blocks per second to a grid disk"
GD_IO_RQ_W_SM "Number of requests to write small blocks to a
grid disk"
GD_IO_RQ_W_SM_SEC "Number of requests to
write small blocks per second to a grid disk"
IORM_MODE "I/O Resource Manager objective for the
cell"
IO_LOAD "Average I/O load for hard
disks"
N_MB_DROP "Number of megabytes droped
during transmission to a particular host"
N_MB_DROP_SEC "Number of megabytes droped during transmission
per second to a particular host"
N_MB_RDMA_DROP
"Number of megabytes dropped during RDMA transmission to a particular
host"
N_MB_RDMA_DROP_SEC "Number of megabytes dropped
during RDMA transmission per second to a particular host"
N_MB_RECEIVED "Number of megabytes received from a particular
host"
N_MB_RECEIVED_SEC "Number of megabytes per
second received from a particular host"
N_MB_RESENT "Number of megabytes resent to a particular
host"
N_MB_RESENT_SEC "Number of megabytes resent
per second to a particular host"
N_MB_SENT
"Number of megabytes transmitted to a particular host"
N_MB_SENT_SEC "Number of megabytes transmitted per second to
a particular host"
N_NIC_NW "Number of
non-working interconnects"
N_NIC_RCV_SEC "Total
number of IO packets received by interconnects per second"
N_NIC_TRANS_SEC "Total number of IO packets transmitted by
interconnects per second"
N_RDMA_RETRY_TM "Latency
of the retry actions during RDMA transmission to a particular host"
'Oracle Exadata' 카테고리의 다른 글
| Exadata의 Smart scan 기능 중 Storage Index 사용 확인 방법 (0) | 2014.11.29 |
|---|---|
| Oracle EXADATA에서 DBFS 구성시 주의사항 (0) | 2013.12.10 |