"오라클 ASM"의 두 판 사이의 차이
DB CAFE
(새 문서: = ASM 이란?= = ASM 조회 = select * from v$asm_disk where group_number = (select group_number from v$asm_diskgroup where name = 'QDATA') order by PATH; sqlplus "/as sysasm" (+AS...) |
(→ASM 조회) |
||
1번째 줄: | 1번째 줄: | ||
= ASM 이란?= | = ASM 이란?= | ||
− | = ASM 조회 = | + | ====== ASM 조회 ===== |
+ | <source lang=sql> | ||
select * from v$asm_disk | select * from v$asm_disk | ||
where group_number = (select group_number from v$asm_diskgroup where name = 'QDATA') | where group_number = (select group_number from v$asm_diskgroup where name = 'QDATA') | ||
order by PATH; | order by PATH; | ||
+ | </source> | ||
sqlplus "/as sysasm" (+ASM instance) | sqlplus "/as sysasm" (+ASM instance) | ||
− | + | ||
+ | <source lang=sql> | ||
+ | ALTER DISKGROUP QDATA DROP DISK DATA_0045 REBALANCE POWER 5; | ||
select * from v$asm_operation; | select * from v$asm_operation; | ||
13번째 줄: | 17번째 줄: | ||
select *--group_number, name, TOTAL_MB, FREE_MB | select *--group_number, name, TOTAL_MB, FREE_MB | ||
from V$asm_disk_stat; | from V$asm_disk_stat; | ||
+ | <source lang=sql> |
2019년 2월 21일 (목) 22:09 판
thumb_up 추천메뉴 바로가기
- DBA { Oracle DBA 명령어 > DBA 초급 과정 > DBA 고급 과정 }
- 튜닝 { 오라클 튜닝 목록 }
- 모델링 { 데이터 모델링 가이드 }
1 ASM 이란?[편집]
1.1 = ASM 조회[편집]
select * from v$asm_disk
where group_number = (select group_number from v$asm_diskgroup where name = 'QDATA')
order by PATH;
sqlplus "/as sysasm" (+ASM instance)
<source lang=sql> ALTER DISKGROUP QDATA DROP DISK DATA_0045 REBALANCE POWER 5;
select * from v$asm_operation;
select *--group_number, name, TOTAL_MB, FREE_MB
from V$asm_disk_stat;
<source lang=sql>