select d.dbid,
d.snap_id,
c.cellhash cell_hash,
extractvalue(xmltype(c.confval),'/cli-output/context/@cell') cell_name,
extractvalue(xmltype(c.confval),
'/cli-output/not-set/hardDiskType') hard_disk_type,
extractvalue(xmltype(c.confval),
'/cli-output/not-set/flashDiskType') flash_disk_type,
to_number(extractvalue(xmltype(c.confval),
'/cli-output/not-set/numCellDisks')) num_cell_disks,
to_number(extractvalue(xmltype(c.confval),
'/cli-output/not-set/numGridDisks')) num_grid_disks,
to_number(extractvalue(xmltype(c.confval),
'/cli-output/not-set/numHardDisks')) num_hard_disks,
to_number(extractvalue(xmltype(c.confval),
'/cli-output/not-set/numFlashDisks')) num_flash_disks,
to_number(
extractvalue(xmltype(c.confval),'/cli-output/not-set/maxPDIOPS'))
max_disk_iops,
to_number(
extractvalue(xmltype(c.confval),'/cli-output/not-set/maxFDIOPS'))
max_flash_iops,
to_number(
extractvalue(xmltype(c.confval),'/cli-output/not-set/maxPDMBPS'))
max_disk_mbps,
to_number(
extractvalue(xmltype(c.confval),'/cli-output/not-set/maxFDMBPS'))
max_flash_mbps,
to_number(extractvalue(xmltype(c.confval),
'/cli-output/not-set/numHardDisks')) *
to_number(extractvalue(xmltype(c.confval),
'/cli-output/not-set/maxPDIOPS')) max_cell_disk_iops,
to_number(extractvalue(xmltype(c.confval),
'/cli-output/not-set/numFlashDisks')) *
to_number(extractvalue(xmltype(c.confval),
'/cli-output/not-set/maxFDIOPS')) max_cell_flash_iops,
to_number(extractvalue(xmltype(c.confval),
'/cli-output/not-set/numHardDisks')) *
to_number(extractvalue(xmltype(c.confval),
'/cli-output/not-set/maxPDMBPS')) max_cell_disk_mbps,
to_number(extractvalue(xmltype(c.confval),
'/cli-output/not-set/numFlashDisks')) *
to_number(extractvalue(xmltype(c.confval),
'/cli-output/not-set/maxFDMBPS')) max_cell_flash_mbps,
decode(d.con_dbid, 0, d.dbid, d.con_dbid) con_dbid,
0 con_id
from wrh$_cell_config_detail d,
wrh$_cell_config c
where d.dbid = c.dbid
and d.cellhash = c.cellhash
and d.conftype = c.conftype
and d.confval_hash = c.confval_hash
and c.conftype = 'AWRXML'
SELECT D.DBID
,
D.SNAP_ID
,
C.CELLHASH CELL_HASH
,
EXTRACTVALUE(XMLTYPE(C.CONFVAL)
, '/CLI-OUTPUT/CONTEXT/@CELL') CELL_NAME
,
EXTRACTVALUE(XMLTYPE(C.CONFVAL)
,
'/CLI-OUTPUT/NOT-SET/HARDDISKTYPE') HARD_DISK_TYPE
,
EXTRACTVALUE(XMLTYPE(C.CONFVAL)
,
'/CLI-OUTPUT/NOT-SET/FLASHDISKTYPE') FLASH_DISK_TYPE
,
TO_NUMBER(EXTRACTVALUE(XMLTYPE(C.CONFVAL)
,
'/CLI-OUTPUT/NOT-SET/NUMCELLDISKS')) NUM_CELL_DISKS
,
TO_NUMBER(EXTRACTVALUE(XMLTYPE(C.CONFVAL)
,
'/CLI-OUTPUT/NOT-SET/NUMGRIDDISKS')) NUM_GRID_DISKS
,
TO_NUMBER(EXTRACTVALUE(XMLTYPE(C.CONFVAL)
,
'/CLI-OUTPUT/NOT-SET/NUMHARDDISKS')) NUM_HARD_DISKS
,
TO_NUMBER(EXTRACTVALUE(XMLTYPE(C.CONFVAL)
,
'/CLI-OUTPUT/NOT-SET/NUMFLASHDISKS')) NUM_FLASH_DISKS
,
TO_NUMBER(
EXTRACTVALUE(XMLTYPE(C.CONFVAL)
, '/CLI-OUTPUT/NOT-SET/MAXPDIOPS'))
MAX_DISK_IOPS
,
TO_NUMBER(
EXTRACTVALUE(XMLTYPE(C.CONFVAL)
, '/CLI-OUTPUT/NOT-SET/MAXFDIOPS'))
MAX_FLASH_IOPS
,
TO_NUMBER(
EXTRACTVALUE(XMLTYPE(C.CONFVAL)
, '/CLI-OUTPUT/NOT-SET/MAXPDMBPS'))
MAX_DISK_MBPS
,
TO_NUMBER(
EXTRACTVALUE(XMLTYPE(C.CONFVAL)
, '/CLI-OUTPUT/NOT-SET/MAXFDMBPS'))
MAX_FLASH_MBPS
,
TO_NUMBER(EXTRACTVALUE(XMLTYPE(C.CONFVAL)
,
'/CLI-OUTPUT/NOT-SET/NUMHARDDISKS')) *
TO_NUMBER(EXTRACTVALUE(XMLTYPE(C.CONFVAL)
,
'/CLI-OUTPUT/NOT-SET/MAXPDIOPS')) MAX_CELL_DISK_IOPS
,
TO_NUMBER(EXTRACTVALUE(XMLTYPE(C.CONFVAL)
,
'/CLI-OUTPUT/NOT-SET/NUMFLASHDISKS')) *
TO_NUMBER(EXTRACTVALUE(XMLTYPE(C.CONFVAL)
,
'/CLI-OUTPUT/NOT-SET/MAXFDIOPS')) MAX_CELL_FLASH_IOPS
,
TO_NUMBER(EXTRACTVALUE(XMLTYPE(C.CONFVAL)
,
'/CLI-OUTPUT/NOT-SET/NUMHARDDISKS')) *
TO_NUMBER(EXTRACTVALUE(XMLTYPE(C.CONFVAL)
,
'/CLI-OUTPUT/NOT-SET/MAXPDMBPS')) MAX_CELL_DISK_MBPS
,
TO_NUMBER(EXTRACTVALUE(XMLTYPE(C.CONFVAL)
,
'/CLI-OUTPUT/NOT-SET/NUMFLASHDISKS')) *
TO_NUMBER(EXTRACTVALUE(XMLTYPE(C.CONFVAL)
,
'/CLI-OUTPUT/NOT-SET/MAXFDMBPS')) MAX_CELL_FLASH_MBPS
,
DECODE(D.CON_DBID
, 0
, D.DBID
, D.CON_DBID) CON_DBID
,
0 CON_ID
FROM WRH$_CELL_CONFIG_DETAIL D
,
WRH$_CELL_CONFIG C
WHERE D.DBID = C.DBID
AND D.CELLHASH = C.CELLHASH
AND D.CONFTYPE = C.CONFTYPE
AND D.CONFVAL_HASH = C.CONFVAL_HASH
AND C.CONFTYPE = 'AWRXML'
|
|
|