개요
V$CELL_CONFIG_INFO 뷰는 셀 서버의 설정 정보를 표시합니다. V$CELL_CONFIG 뷰와 구조가 유사하지만 저장된 정보가 상이하고 데이터가 즉시 갱신된다는 점에서 차이가 있습니다. 뷰의 데이터는 AWR의 DBA_HIST_CELL_CONFIG, DBA_HIST_CELL_CONFIG_DETAIL 뷰에 저장됩니다.
칼럼 구성은 아래와 같습니다. conftype 칼럼에 설정 유형, confval 칼럼에 설정 값이 저장되어 있습니다.
이름 널? 유형
------------ --- --------------
CELLNAME VARCHAR2(1024)
CELLHASH NUMBER
CONFTYPE VARCHAR2(15) -- 설정 유형
CONFVAL_HASH NUMBER
CONFVAL CLOB -- 설정 값(XML)
CON_ID NUMBER
설정 유형은 아래와 같습니다. 설정 유형에 따라 상이한 XML 포맷의 설정 값이 저장되어 있습니다.
- AWRXML
- CELL
- CELLDISK
- GRIDDISK
- IORM_OBJ: I/O Resource Management Objective
- OFFLOAD
- PHYSICALDISK
설정 값은 아래의 쿼리로 조회할 수 있습니다.
AWRXML
-- AWRXML
SELECT EXTRACTVALUE(XMLTYPE (a.confval), '/cli-output/context/@cell') AS cell
, b.*
FROM v$cell_config_info a
, XMLTABLE ('/cli-output/not-set'
PASSING XMLTYPE (a.confval)
COLUMNS
effective_flash_cache_size NUMBER PATH 'effectiveFlashCacheSize'
, effective_pmem_cache_size NUMBER PATH 'effectivePmemCacheSize'
, effective_flash_log_size NUMBER PATH 'effectiveFlashLogSize'
, effective_pmem_log_size NUMBER PATH 'effectivePmemLogSize'
, num_grid_disks NUMBER PATH 'numGridDisks'
, num_cell_disks NUMBER PATH 'numCellDisks'
, cell_pkg VARCHAR2(256) PATH 'cellPkg'
, infiniband_pkg VARCHAR2(256) PATH 'infinibandPkg'
, hard_disk_type VARCHAR2(256) PATH 'hardDiskType'
, flash_disk_type VARCHAR2(256) PATH 'flashDiskType'
, num_hard_disks NUMBER PATH 'numHardDisks'
, num_flash_disks NUMBER PATH 'numFlashDisks'
, flash_cache_status VARCHAR2(256) PATH 'flashCacheStatus'
, num_pmem NUMBER PATH 'numPmem'
, pmem_type VARCHAR2(256) PATH 'pmemType'
, pmem_cache_status VARCHAR2(256) PATH 'pmemCacheStatus'
, max_pd_iops NUMBER PATH 'maxPDIOPS'
, max_fd_iops NUMBER PATH 'maxFDIOPS'
, max_pd_mbps NUMBER PATH 'maxPDMBPS'
, max_fd_mbps NUMBER PATH 'maxFDMBPS'
, dwh_pd_ql NUMBER PATH 'dwhPDQL'
, dwh_fd_ql NUMBER PATH 'dwhFDQL'
, oltp_pd_ql NUMBER PATH 'oltpPDQL'
, oltp_fd_ql NUMBER PATH 'oltpFDQL'
) b
WHERE a.conftype = 'AWRXML'
ORDER BY cell;
CELL
-- CELL
SELECT EXTRACTVALUE(XMLTYPE (a.confval), '/cli-output/context/@cell') AS cell
, b.*
FROM v$cell_config_info a
, XMLTABLE ('/cli-output/cell'
PASSING XMLTYPE (a.confval)
COLUMNS
name VARCHAR2(256) PATH 'name'
, cpu_count VARCHAR2(256) PATH 'cpuCount'
, memory_gb NUMBER PATH 'memoryGB'
, make_model VARCHAR2(256) PATH 'makeModel'
, kernel_version VARCHAR2(256) PATH 'kernelVersion'
, flash_cache_mode VARCHAR2(256) PATH 'flashCacheMode'
, max_pd_iops NUMBER PATH 'maxPDIOPS'
, max_fd_iops NUMBER PATH 'maxFDIOPS'
, max_pd_mbps NUMBER PATH 'maxPDMBPS'
, max_fd_mbps NUMBER PATH 'maxFDMBPS'
, dwh_pd_ql NUMBER PATH 'dwhPDQL'
, dwh_fd_ql NUMBER PATH 'dwhFDQL'
, oltp_pd_ql NUMBER PATH 'oltpPDQL'
, oltp_fd_ql NUMBER PATH 'oltpFDQL'
, ram_cache_mode VARCHAR2(256) PATH 'ramCacheMode'
, ram_cache_size NUMBER PATH 'ramCacheSize'
, ram_cache_max_size NUMBER PATH 'ramCacheMaxSize'
, pmem_cache_mode VARCHAR2(256) PATH 'pmemCacheMode'
) b
WHERE a.conftype = 'CELL'
ORDER BY cell;
CELLDISK
-- CELLDISK
SELECT EXTRACTVALUE(XMLTYPE (a.confval), '/cli-output/context/@cell') AS cell
, b.*
FROM v$cell_config_info a
, XMLTABLE ('/cli-output/celldisk'
PASSING XMLTYPE (a.confval)
COLUMNS
name VARCHAR2(256) PATH 'name'
, size_ NUMBER PATH 'size'
, disk_type VARCHAR2(256) PATH 'diskType'
, id VARCHAR2(256) PATH 'id'
, device_name VARCHAR2(256) PATH 'deviceName'
, physical_disk VARCHAR2(256) PATH 'physicalDisk'
) b
WHERE a.conftype = 'CELLDISK'
ORDER BY cell
, b.name;
GRIDDISK
-- GRIDDISK
SELECT EXTRACTVALUE(XMLTYPE (a.confval), '/cli-output/context/@cell') AS cell
, b.*
FROM v$cell_config_info a
, XMLTABLE ('/cli-output/griddisk'
PASSING XMLTYPE (a.confval)
COLUMNS
name VARCHAR2(256) PATH 'name'
, size_ NUMBER PATH 'size'
, cell_disk VARCHAR2(256) PATH 'cellDisk'
, id VARCHAR2(256) PATH 'id'
, caching_policy VARCHAR2(256) PATH 'cachingPolicy'
) b
WHERE a.conftype = 'GRIDDISK'
ORDER BY cell
, b.name;
IORM_OBJ
-- IORM_OBJ
SELECT EXTRACTVALUE(XMLTYPE (a.confval), '/cli-output/context/@cell') AS cell
, b.*
FROM v$cell_config_info a
, XMLTABLE ('/cli-output/iormplan'
PASSING XMLTYPE (a.confval)
COLUMNS
objective VARCHAR2(256) PATH 'objective'
) b
WHERE a.conftype = 'IORM_OBJ'
ORDER BY cell;
OFFLOAD
-- OFFLOAD
SELECT EXTRACTVALUE(XMLTYPE (a.confval), '/cli-output/context/@cell') AS cell
, b.*
FROM v$cell_config_info a
, XMLTABLE ('/cli-output/offloadgroup'
PASSING XMLTYPE (a.confval)
COLUMNS
name VARCHAR2(256) PATH 'name'
, package VARCHAR2(256) PATH 'package'
) b
WHERE a.conftype = 'OFFLOAD'
ORDER BY cell
, b.name;
PHYSICALDISK
-- PHYSICALDISK
SELECT EXTRACTVALUE(XMLTYPE (a.confval), '/cli-output/context/@cell') AS cell
, b.*
FROM v$cell_config_info a
, XMLTABLE ('/cli-output/physicaldisk'
PASSING XMLTYPE (a.confval)
COLUMNS
name VARCHAR2(256) PATH 'name'
, device_name VARCHAR2(256) PATH 'deviceName'
, physical_serial VARCHAR2(256) PATH 'physicalSerial'
, flash_life_left NUMBER PATH 'flashLifeLeft'
) b
WHERE a.conftype = 'PHYSICALDISK'
ORDER BY cell
, b.name;