设为首页 加入收藏

TOP

Oracle ASM 常用命令
2019-03-21 00:08:18 】 浏览:63
Tags:Oracle ASM 常用 命令

01, 查看磁盘路径


select name,path,group_number from v$asm_disk_stat;


02, 查看磁盘组信息


select state,name,type,total_mb, free_mb from v$asm_diskgroup_stat ;  


磁盘组状态为Mounted说明磁盘组状态正常;


磁盘组的total_mb,free_mb为非0说明可以读取磁盘信息,获取磁盘大小。



03,查看磁盘组操作


select * from v$asm_operation;


 04,查看磁盘组属性


SELECT dg.name AS diskgroup,SUBSTR(a.name,1,18) AS name,SUBSTR(a.value,1,24) AS value, read_only FROM v$ASM_DISKGROUP_STAT dg,
v$ASM_ATTRIBUTE a WHERE dg.name = 'DATA' AND dg.group_number = a.group_number;


 05, 查看磁盘组的兼容属性


SELECT name,COMPATIBILITY,DATABASE_COMPATIBILITY FROM V$ASM_DISKGROUP_STAT;


 06, 查看磁盘状态


SELECT SUBSTR(d.name,1,16) AS asmdisk,d.mount_status,HEADER_STATUS, d.state,dg.name AS diskgroup FROM V$ASM_DISKGROUP_STAT  dg,V$ASM_DISK_STAT d WHERE dg.group_number = d.group_number;


07,查看磁盘客户端信息


SELECT dg.name AS diskgroup,SUBSTR(c.instance_name,1,12) AS instance,SUBSTR(c.db_name,1,12) AS dbname,SUBSTR(c.SOFTWARE_VERSION,1,12) AS software, SUBSTR(c.COMPATIBLE_VERSION,1,12) AS compatible FROM V$ASM_DISKGROUP_STAT  dg, V$ASM_CLIENT c WHERE dg.group_number = c.group_number;


 08, 查看磁盘访问控制用户信息


SELECT dg.name AS diskgroup, u.group_number,u.user_number, u.os_id, u.os_name FROM V$ASM_DISKGROUP_STAT  dg, V$ASM_USER u WHERE dg.group_number = u.group_number AND dg.name ='DATA';


09,查看磁盘访问控制组信息


SELECT dg.name AS diskgroup, ug.group_number,ug.owner_number, u.os_name,ug.usergroup_number, ug.name FROM V$ASM_DISKGROUP_STAT dg,V$ASM_USER u, V$ASM_USERGROUP ug WHERE dg.group_number = ug.group_number AND dg.name ='DATA' AND ug.owner_number = u.user_number;


10,查看智能数据分布

信息


SELECT dg.name AS diskgroup, f.file_number, f.primary_region,f.mirror_region,f.hot_reads,f.hot_writes, f.cold_reads, f.cold_writes FROM V$ASM_DISKGROUP_STAT  dg, V$ASM_FILE f WHERE dg.group_number = f.group_number and dg.name ='DATA';



编程开发网
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇Oracle broker 详解 下一篇Oracle Linux Server 6.9下Oracle..

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

array(4) { ["type"]=> int(8) ["message"]=> string(24) "Undefined variable: jobs" ["file"]=> string(32) "/mnt/wp/cppentry/do/bencandy.php" ["line"]=> int(217) }