从视图获得asm信息。 - 数据库编程

OUP1 325 80 P /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 80 M /dev/oracleasm/disks/ASMDISK4 DATAGROUP1 325 81 P /dev/oracleasm/disks/ASMDISK2 DATAGROUP1 325 81 M /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 82 P /dev/oracleasm/disks/ASMDISK4 NAME FILE NUMBER EXTENT NUMBER EX PATH ---------------------------------------- ----------- ------------- -- ------------------------------------------------------------ DATAGROUP1 325 82 M /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 83 P /dev/oracleasm/disks/ASMDISK1 DATAGROUP1 325 83 M /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 84 P /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 84 M /dev/oracleasm/disks/ASMDISK1 DATAGROUP1 325 85 P /dev/oracleasm/disks/ASMDISK2 DATAGROUP1 325 85 M /dev/oracleasm/disks/ASMDISK1 DATAGROUP1 325 86 P /dev/oracleasm/disks/ASMDISK4 DATAGROUP1 325 86 M /dev/oracleasm/disks/ASMDISK1 DATAGROUP1 325 87 P /dev/oracleasm/disks/ASMDISK1 DATAGROUP1 325 87 M /dev/oracleasm/disks/ASMDISK4 NAME FILE NUMBER EXTENT NUMBER EX PATH ---------------------------------------- ----------- ------------- -- ------------------------------------------------------------ DATAGROUP1 325 88 P /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 88 M /dev/oracleasm/disks/ASMDISK2 DATAGROUP1 325 89 P /dev/oracleasm/disks/ASMDISK2 DATAGROUP1 325 89 M /dev/oracleasm/disks/ASMDISK4 DATAGROUP1 325 90 P /dev/oracleasm/disks/ASMDISK4 DATAGROUP1 325 90 M /dev/oracleasm/disks/ASMDISK2 DATAGROUP1 325 91 P /dev/oracleasm/disks/ASMDISK1 DATAGROUP1 325 91 M /dev/oracleasm/disks/ASMDISK2 DATAGROUP1 325 92 P /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 92 M /dev/oracleasm/disks/ASMDISK4 DATAGROUP1 325 93 P /dev/oracleasm/disks/ASMDISK2 NAME FILE NUMBER EXTENT NUMBER EX PATH ---------------------------------------- ----------- ------------- -- ------------------------------------------------------------ DATAGROUP1 325 93 M /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 94 P /dev/oracleasm/disks/ASMDISK4 DATAGROUP1 325 94 M /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 95 P /dev/oracleasm/disks/ASMDISK1 DATAGROUP1 325 95 M /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 96 P /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 96 M /dev/oracleasm/disks/ASMDISK1 DATAGROUP1 325 97 P /dev/oracleasm/disks/ASMDISK2 DATAGROUP1 325 97 M /dev/oracleasm/disks/ASMDISK1 DATAGROUP1 325 98 P /dev/oracleasm/disks/ASMDISK4 DATAGROUP1 325 98 M /dev/oracleasm/disks/ASMDISK1 NAME FILE NUMBER EXTENT NUMBER EX PATH ---------------------------------------- ----------- ------------- -- ------------------------------------------------------------ DATAGROUP1 325 99 P /dev/oracleasm/disks/ASMDISK1 DATAGROUP1 325 99 M /dev/oracleasm/disks/ASMDISK4 DATAGROUP1 325 100 P /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 100 M /dev/oracleasm/disks/ASMDISK2 DATAGROUP1 325 2147483648 P /dev/oracleasm/disks/ASMDISK2 DATAGROUP1 325 2147483648 M /dev/oracleasm/disks/ASMDISK3 DATAGROUP1 325 2147483648 MM /dev/oracleasm/disks/ASMDISK4 205 rows selected. SQL>

可以看到在normal情况下，每个区都是存在镜像的，且默认创建一个表空间指定的文件为100Mb。

2、查看相关视图获得asm 磁盘组的信息。见如下神图（摘自网络）：

从视图获得asm信息。(五)