Oracle教程 2023-02-24

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

本站中文解释

Oracle视图V$ASM_ATTRIBUTE是在使用Oracle ASM 时用来列出存储配置属性的一个视图。它依靠10个不同的列给出了关于Oracle ASM存储是如何安排在系统中的信息。

用途：

主要用于查看和管理Oracle ASM实例的配置属性以及所有Oracle ASM磁盘组的详细信息，可以查看现有的ASM 属性和状态，以及它们的变化。

使用：

1. 查询某个Oracle ASM实例：

SELECT name,value
FROM v$asm_attribute
where name = ‘instance_name’;

2. 查询某个Oracle ASM磁盘组：

SELECT name,value
from v$asm_attribute
where name = ‘name’
AND value = ‘diskgroup_name’;

3. 查询某个Oracle ASM磁盘：

SELECT name,value
from v$asm_attribute
where name = ‘diskgroup_name’
AND value = ‘diskname’;

官方英文解释

V$ASM_ATTRIBUTE displays one row for each attribute defined. In addition to attributes specified by CREATE DISKGROUP and ALTER DISKGROUP statements, the view may show other attributes that are created automatically.

Note that attributes are only displayed for disk groups where COMPATIBLE.ASM is set to 11.1 or higher.

Column	Datatype	Description
`NAME`	`VARCHAR2(256)`	Full name of the attribute
`VALUE`	`VARCHAR2(256)`	Value of the attribute
`GROUP_NUMBER`	`NUMBER`	Number of the disk group in which this attribute exists (composite primary key)
`ATTRIBUTE_INDEX`	`NUMBER`	Number of this attribute in the disk group (composite primary key)
`ATTRIBUTE_INCARNATION`	`NUMBER`	Incarnation number for this attribute (composite primary key)
`READ_ONLY`	`VARCHAR2(7)`	Indicates whether the attribute is read-only (`Y`) or not (`N`)
`SYSTEM_CREATED`	`VARCHAR2(7)`	Indicates whether this is a system-created attribute (`Y`) or not (`N`)
`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`.

Note:

In an Oracle Database instance, this view returns 0 rows when queried from a PDB.

本站中文解释

官方英文解释

相关推荐