Oracle ASM 常用巡检脚本

发布时间 2024-01-01 16:38:20作者: 小yq

1.查看磁盘组

sqlplus "/ as sysasm"
set line 200
set pagesize 200
select group_number,name,state,type,total_mb,free_mb,usable_file_mb,offline_disks from v$asm_diskgroup;

2.看磁盘的

set line 200
set pagesize 200
col name format a20
col path format a30
select name,mount_Status,state,disk_number,path,total_mb,free_mb,group_number from v$asm_disk;