개요
V$CELL_CONFIG 뷰는 셀 서버의 설정 정보를 표시합니다. 데이터는 하루 한번 오전 7시 ~ 9시 사이에 갱신되는 것으로 보입니다.
칼럼 구성은 아래와 같습니다. conftype 칼럼에 설정 유형, confval 칼럼에 설정 값이 저장되어 있습니다.
이름 널? 유형
-------- --- --------------
CELLNAME VARCHAR2(1024)
CELLHASH NUMBER
CONFTYPE VARCHAR2(15) -- 설정 유형
CONFVAL CLOB -- 설정 값(XML)
CON_ID NUMBER
설정 유형은 아래와 같습니다. 설정 유형에 따라 상이한 XML 포맷의 설정 값이 저장되어 있습니다.
- CELL
- CELLDISKS
- GRIDDISKS
- IORM: I/O Resource Management
- LUNS: Logical Unit Number
- PHYSICALDISKS
설정 값은 아래의 쿼리로 조회할 수 있습니다.
CELL
-- CELL
SELECT DATE '1970-01-01' + NUMTODSINTERVAL (EXTRACTVALUE(XMLTYPE (a.confval), '/cli-output/timestamp') / 1000,'SECOND') AS timestamp
, EXTRACTVALUE(XMLTYPE (a.confval), '/cli-output/context/@cell') AS cell
, b.*
FROM v$cell_config a
, XMLTABLE ('/cli-output/cell'
PASSING XMLTYPE (a.confval)
COLUMNS
name VARCHAR2(256) PATH 'name'
, access_level_perm VARCHAR2(256) PATH 'accessLevelPerm'
, bbu_status VARCHAR2(256) PATH 'bbuStatus'
, cell_version VARCHAR2(256) PATH 'cellVersion'
, cpu_count VARCHAR2(256) PATH 'cpuCount'
, diag_history_days NUMBER PATH 'diagHistoryDays'
, do_not_service_led_status VARCHAR2(256) PATH 'doNotServiceLEDStatus'
, fan_count VARCHAR2(256) PATH 'fanCount'
, fan_status VARCHAR2(256) PATH 'fanStatus'
, flash_cache_mode VARCHAR2(256) PATH 'flashCacheMode'
, https_access VARCHAR2(256) PATH 'httpsAccess'
, id VARCHAR2(256) PATH 'id'
, ilom_ip_address VARCHAR2(256) PATH 'ilomIpAddress'
, interconnect_count NUMBER PATH 'interconnectCount'
, interconnect1 VARCHAR2(256) PATH 'interconnect1'
, interconnect2 VARCHAR2(256) PATH 'interconnect2'
, iorm_boost VARCHAR2(256) PATH 'iormBoost'
, ipaddress1 VARCHAR2(256) PATH 'ipaddress1'
, ipaddress2 VARCHAR2(256) PATH 'ipaddress2'
, kernel_version VARCHAR2(256) PATH 'kernelVersion'
, locator_led_status VARCHAR2(256) PATH 'locatorLEDStatus'
, make_model VARCHAR2(256) PATH 'makeModel'
, management_ip_address VARCHAR2(256) PATH 'managementIpAddress'
, memory_gb NUMBER PATH 'memoryGB'
, metric_history_days NUMBER PATH 'metricHistoryDays'
, offload_group_events VARCHAR2(256) PATH 'offloadGroupEvents'
, power_count VARCHAR2(256) PATH 'powerCount'
, power_status VARCHAR2(256) PATH 'powerStatus'
, release_image_status VARCHAR2(256) PATH 'releaseImageStatus'
, release_version VARCHAR2(256) PATH 'releaseVersion'
, rpm_version VARCHAR2(256) PATH 'rpmVersion'
, release_tracking_bug VARCHAR2(256) PATH 'releaseTrackingBug'
, rollback_version VARCHAR2(256) PATH 'rollbackVersion'
, status VARCHAR2(256) PATH 'status'
, temperature_reading VARCHAR2(256) PATH 'temperatureReading'
, temperature_status VARCHAR2(256) PATH 'temperatureStatus'
, up_time VARCHAR2(256) PATH 'upTime'
, usb_status VARCHAR2(256) PATH 'usbStatus'
) b
WHERE a.conftype = 'CELL'
ORDER BY cell;
CELLDISKS
-- CELLDISKS
SELECT DATE '1970-01-01' + NUMTODSINTERVAL (EXTRACTVALUE(XMLTYPE (a.confval), '/cli-output/timestamp') / 1000,'SECOND') AS timestamp
, EXTRACTVALUE(XMLTYPE (a.confval), '/cli-output/context/@cell') AS cell
, b.name
, b.comment_
, TO_TIMESTAMP_TZ (b.creation_time, 'YYYY-MM-DD"T"HH24:MI:SSTZH:TZM') AS creation_time
, b.device_name
, b.device_partition
, b.disk_type
, b.error_count
, b.free_space
, b.id
, b.physical_disk
, b.size_
, b.status
FROM v$cell_config a
, XMLTABLE ('/cli-output/celldisk'
PASSING XMLTYPE (a.confval)
COLUMNS
name VARCHAR2(256) PATH 'name'
, comment_ VARCHAR2(256) PATH 'comment'
, creation_time VARCHAR2(256) PATH 'creationTime'
, device_name VARCHAR2(256) PATH 'deviceName'
, device_partition VARCHAR2(256) PATH 'devicePartition'
, disk_type VARCHAR2(256) PATH 'diskType'
, error_count NUMBER PATH 'errorCount'
, free_space NUMBER PATH 'freeSpace'
, id VARCHAR2(256) PATH 'id'
, physical_disk VARCHAR2(256) PATH 'physicalDisk'
, size_ NUMBER PATH 'size'
, status VARCHAR2(256) PATH 'status'
) b
WHERE a.conftype = 'CELLDISKS'
ORDER BY cell
, b.name;
GRIDDISKS
-- GRIDDISKS
SELECT DATE '1970-01-01' + NUMTODSINTERVAL (EXTRACTVALUE(XMLTYPE (a.confval), '/cli-output/timestamp') / 1000,'SECOND') AS timestamp
, EXTRACTVALUE(XMLTYPE (a.confval), '/cli-output/context/@cell') AS cell
, b.*
FROM v$cell_config a
, XMLTABLE ('/cli-output/griddisk'
PASSING XMLTYPE (a.confval)
COLUMNS
name VARCHAR2(256) PATH 'name'
, asm_disk_group_name VARCHAR2(256) PATH 'asmDiskGroupName'
, asm_disk_name VARCHAR2(256) PATH 'asmDiskName'
, asm_fail_group_name VARCHAR2(256) PATH 'asmFailGroupName'
, available_to VARCHAR2(256) PATH 'availableTo'
, cached_by VARCHAR2(256) PATH 'cachedBy'
, caching_policy VARCHAR2(256) PATH 'cachingPolicy'
, cell_disk VARCHAR2(256) PATH 'cellDisk'
, comment_ VARCHAR2(256) PATH 'comment'
, creation_time VARCHAR2(256) PATH 'creationTime'
, disk_type VARCHAR2(256) PATH 'diskType'
, error_count NUMBER PATH 'errorCount'
, id VARCHAR2(256) PATH 'id'
, size_ NUMBER PATH 'size'
, status VARCHAR2(256) PATH 'status'
) b
WHERE a.conftype = 'GRIDDISKS'
ORDER BY cell
, b.name;
IORM
-- IORM
SELECT DATE '1970-01-01' + NUMTODSINTERVAL (EXTRACTVALUE(XMLTYPE (a.confval), '/cli-output/timestamp') / 1000,'SECOND') AS timestamp
, EXTRACTVALUE(XMLTYPE (a.confval), '/cli-output/context/@cell') AS cell
, b.*
FROM v$cell_config a
, XMLTABLE ('/cli-output/iormplan'
PASSING XMLTYPE (a.confval)
COLUMNS
name VARCHAR2(256) PATH 'name'
, cat_plan VARCHAR2(256) PATH 'catPlan'
, db_plan VARCHAR2(256) PATH 'dbPlan'
, cluster_plan VARCHAR2(256) PATH 'clusterPlan'
, objective VARCHAR2(256) PATH 'objective'
, status VARCHAR2(256) PATH 'status'
) b
WHERE a.conftype = 'IORM'
ORDER BY cell
, b.name;
LUNS
-- LUNS
SELECT DATE '1970-01-01' + NUMTODSINTERVAL (EXTRACTVALUE(XMLTYPE (a.confval), '/cli-output/timestamp') / 1000,'SECOND') AS timestamp
, EXTRACTVALUE(XMLTYPE (a.confval), '/cli-output/context/@cell') AS cell
, b.*
FROM v$cell_config a
, XMLTABLE ('/cli-output/lun'
PASSING XMLTYPE (a.confval)
COLUMNS
name VARCHAR2(256) PATH 'name'
, device_name VARCHAR2(256) PATH 'deviceName'
, disk_type VARCHAR2(256) PATH 'diskType'
, id VARCHAR2(256) PATH 'id'
, is_system_lun VARCHAR2(256) PATH 'isSystemLun'
, lun_size VARCHAR2(256) PATH 'lunSize'
, lun_uid VARCHAR2(256) PATH 'lunUID'
, physical_drives VARCHAR2(256) PATH 'physicalDrives'
, raid_level VARCHAR2(256) PATH 'raidLevel'
, lun_write_cache_mode VARCHAR2(256) PATH 'lunWriteCacheMode'
, status VARCHAR2(256) PATH 'status'
) b
WHERE a.conftype = 'LUNS'
ORDER BY cell
, b.name;
PHYSICALDISKS
-- PHYSICALDISKS
SELECT DATE '1970-01-01' + NUMTODSINTERVAL (EXTRACTVALUE(XMLTYPE (a.confval), '/cli-output/timestamp') / 1000,'SECOND') AS timestamp
, EXTRACTVALUE(XMLTYPE (a.confval), '/cli-output/context/@cell') AS cell
, b.name
, b.device_id
, b.device_name
, b.disk_type
, b.enclosure_deviceid
, b.err_other_count
, b.luns
, b.make_model
, b.physical_firmware
, TO_TIMESTAMP_TZ (b.physical_insert_time, 'YYYY-MM-DD"T"HH24:MI:SSTZH:TZM') AS physical_insert_time
, b.physical_interface
, b.physical_serial
, b.physical_size
, b.slot_number
, b.status
FROM v$cell_config a
, XMLTABLE ('/cli-output/physicaldisk'
PASSING XMLTYPE (a.confval)
COLUMNS
name VARCHAR2(256) PATH 'name'
, device_id VARCHAR2(256) PATH 'deviceId'
, device_name VARCHAR2(256) PATH 'deviceName'
, disk_type VARCHAR2(256) PATH 'diskType'
, enclosure_deviceid VARCHAR2(256) PATH 'enclosureDeviceId'
, err_other_count NUMBER PATH 'errOtherCount'
, luns VARCHAR2(256) PATH 'luns'
, make_model VARCHAR2(256) PATH 'makeModel'
, physical_firmware VARCHAR2(256) PATH 'physicalFirmware'
, physical_insert_time VARCHAR2(256) PATH 'physicalInsertTime'
, physical_interface VARCHAR2(256) PATH 'physicalInterface'
, physical_serial VARCHAR2(256) PATH 'physicalSerial'
, physical_size NUMBER PATH 'physicalSize'
, slot_number VARCHAR2(256) PATH 'slotNumber'
, status VARCHAR2(256) PATH 'status'
) b
WHERE a.conftype = 'PHYSICALDISKS'
ORDER BY cell
, b.name;