查询ASM与存储的信息

来源:互联网 发布:围棋算法 编辑:程序博客网 时间:2024/06/02 01:08
SET line 120
col NAME FOR a20 
col PATH FOR a30
col mode_status FOR a11
col voting_files FOR a12
SELECT group_number,name,total_mb,free_mb,voting_files FROM v$asm_diskgroup ORDER BY group_number;
SELECT NAME,PATH,mode_status  FROM v$asm_disk ORDER BY NAME;
0 0