오라클 Exadata cellcli list 명령에서 attributes 목록 확인

EXADATA Image : 22.1.33.0.0.250304

 

OS 환경 : Oracle Linux 7.9 (64bit)

 

DB 환경 : Oracle Database 19.31.0.0

 

방법 : 오라클 Exadata cellcli list 명령에서 attributes 목록 확인

exadata의 cellcli 명령에서 attributes를 입력해서 원하는 컬럼만 확인할 수 있음

1 2 3 4 5 6 7 8 9 10 11 12 13 14

CellCLI> list physicaldisk attributes name, diskType, status list physicaldisk attributes name, diskType, status          252:0           HardDisk        normal          252:1           HardDisk        normal          252:2           HardDisk        warning - predictive failure          252:3           HardDisk        normal          252:4           HardDisk        normal          252:5           HardDisk        normal          FLASH_10_1      FlashDisk       normal          FLASH_10_2      FlashDisk       normal          FLASH_5_1       FlashDisk       normal          FLASH_5_2       FlashDisk       normal          M2_SYS_0        M2Disk          normal          M2_SYS_1        M2Disk          normal

 

 

하지만 어떤 컬럼이 있는지 모르는 경우 아래 명령처럼 detail 명령을 사용해서 보기도 함

1 2 3 4 5 6 7 8 9 10 11 12 13

CellCLI> LIST CELLDISK CD_00_GDX7CELADM01 DETAIL LIST CELLDISK CD_00_GDX7CELADM01 DETAIL          name:                   CD_00_exa7celadm01          comment:          creationTime:           2026-07-21T09:53:31+09:00          deviceName:             /dev/sda          devicePartition:        /dev/sda          diskType:               HardDisk          freeSpace:              0          id:                     1ae1cafd-1655-4cc5-b0c8-7ad89f74996e          physicalDisk:           RAMKKD          size:                   8.9094085693359375T          status:                 normal

 

 

하지만 list metrichistory 처럼 결과가 아주 많이 나오는 경우 나오는데 시간도 걸리고 읽기 어려울 수 있음

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

CellCLI> LIST METRICHISTORY CD_IO_ERRS_MIN DETAIL LIST METRICHISTORY CD_IO_ERRS_MIN DETAIL          name:                   CD_IO_ERRS_MIN          alertState:             normal          collectionTime:         2026-07-23T16:59:02+09:00          metricObjectName:       CD_03_exa7celadm01          metricType:             Rate          metricValue:            0.0 /min          objectType:             CELLDISK            name:                   CD_IO_ERRS_MIN          alertState:             normal          collectionTime:         2026-07-23T16:59:02+09:00          metricObjectName:       CD_04_exa7celadm01          metricType:             Rate          metricValue:            0.0 /min          objectType:             CELLDISK ...

 

 

이때는 describe 명령을 사용하면 컬럼들만 바로 확인할 수 있음

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

CellCLI> DESCRIBE METRICHISTORY DESCRIBE METRICHISTORY         name         alertState         collectionTime         metricObjectName         metricType         metricValue         metricValueAvg         metricValueMax         metricValueMin         objectType   CellCLI> DESCRIBE CELLDISK DESCRIBE CELLDISK         name                   modifiable         comment                modifiable         creationTime         deviceName         devicePartition         diskType         errorCount             hidden         flushError             hidden         flushStatus            hidden         freeSpace         id         physicalDisk         size                   modifiable         status

 

 

만약 실제 데이터도 한건만 보고싶은경우 sql처럼 order by + limit 절을 사용할 수 있음

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

CellCLI> LIST CELLDISK DETAIL - ORDER BY name DESC LIMIT 1 LIST CELLDISK DETAIL -            name:                   FD_01_exa7celadm01          comment:          creationTime:           2026-07-21T09:53:31+09:00          deviceName:             /dev/md305          devicePartition:        /dev/md305          diskType:               FlashDisk          freeSpace:              0          id:                     3f17888e-55de-4ae0-9fd6-9900b2aea5c8          physicalDisk:           PHLE812000836P4BGN-2,PHLE812000836P4BGN-1          size:                   5.8218994140625T          status:                 normal

 

 

결론 :
cellcli에서 특정 목록의 컬럼만 보려면 describe 명령을 사용하면 편리하게 확인 가능함
만약 샘플로 1건만 보고 싶다면 order by + limit 절을 사용할 수도 있음

 

 

참조 : 

https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/describe.html
https://docs.oracle.com/cd/F16836_01/sagug/system-software-users-guide-exadata-database-machine.pdf