Oracle教程 2023-02-24

Oracle 视图 V$ASM_VOLUME 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图V$ASM_VOLUME是一个动态视图，它能查看和监控存储在ASM磁盘中的卷信息。应用程序可以通过该视图来查看由高可用存储管理器(ASM)管理的卷信息，例如卷的个数，卷容量，卷名称等。使用该视图，用户可以查看ASM磁盘组和ASM卷组的相关信息，以及ASM存储（例如振荡器）的状态。

要使用V$ASM_VOLUME视图，首先需要登录，然后使用下面的SQL查询获取信息：

–查看ASM磁盘上的所有卷
SELECT diskgroup_name,volume_name,volume_path,block_size,file_size,volume_status
FROM v$asm_volume;

–查询ASM磁盘组和ASM卷组
SELECT diskgroup_name,redundancy,total_mb,free_mb
FROM v$asm_diskgroup;

–查询ASM振荡器的状态
SELECT *
FROM v$asm_disk_stat;

官方英文解释

In an Oracle Automatic Storage Management (Oracle ASM) instance, V$ASM_VOLUME displays information about each Oracle ADVM volume.

Column	Datatype	Description
`GROUP_NUMBER`	`NUMBER`	Cluster-wide number assigned to the disk group (composite primary key)
`VOLUME_NAME`	`VARCHAR2(30)`	Name of the volume
`COMPOUND_INDEX`	`NUMBER`	A 32-bit number consisting of a disk group number in the high-order 8 bits and a volume number in the low-order 24 bits (for efficient access to the view)
`SIZE_MB`	`NUMBER`	Size of the volume (in megabytes)
`VOLUME_NUMBER`	`NUMBER`	Number of the Volume within the disk group (composite primary key)
`REDUNDANCY`	`VARCHAR2(6)`	Redundancy type for the volume: `UNPROT` `HIGH` `MIRROR`
`STRIPE_COLUMNS`	`NUMBER`	Number of columns in a stripe set
`STRIPE_WIDTH_K`	`NUMBER`	Stripe width of the volume (in kilobytes)
`STATE`	`VARCHAR2(8)`	Indicates whether the volume is enabled (`ENABLED`), disabled (`DISABLED`), or remote (`REMOTE`)
`FILE_NUMBER`	`NUMBER`	Volume file number
`INCARNATION`	`NUMBER`	Volume file incarnation number
`DRL_FILE_NUMBER`	`NUMBER`	Volume Dirty Region Logging (DRL) file used for mirrored volumes
`RESIZE_UNIT_MB`	`NUMBER`	Volume allocation unit (in megabytes) that a volume can be created
`USAGE`	`VARCHAR2(30)`	Optional usage string for the volume
`VOLUME_DEVICE`	`VARCHAR2(256)`	OSD path for the volume device
`MOUNTPATH`	`VARCHAR2(1024)`	Optional mount path string for the volume
`PRIMARY_REGION`^Foot 1	`VARCHAR2(4)`	Region used for allocating primary extents: `HOT` `COLD`
`MIRROR_REGION`^Foot 1	`VARCHAR2(4)`	Region used for allocating mirrored extents: `HOT` `COLD`
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data For this view, the value is always `0`.

^Footnote 1Intelligent Data Placement is desupported starting with Oracle Database 21c. As a result, the PRIMARY_REGION and MIRROR_REGION columns are no longer meaningful.

本站中文解释

官方英文解释

相关推荐