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

本站中文解释

Oracle V$ASM_TEMPLATE是一个数据字典视图，可以用来查看ASM模板的信息，包括模板的大小、字节数、组、存储ID、类型、子类型和标签。

使用V$ASM_TEMPLATE可以进行如下操作：

1. 查看ASM模板文件是否存在：通过查询V$ASM_TEMPLATE视图，可以查询ASM模板文件是否存在

2. 查询ASM模板文件的大小：通过查询V$ASM_TEMPLATE视图，可以查询ASM模板文件的大小

3. 查询ASM模板文件的组：通过查询V$ASM_TEMPLATE视图，可以查询ASM模板文件的组

4. 查询ASM模板文件的字节数：通过查询V$ASM_TEMPLATE视图，可以查询ASM模板文件的字节数

5. 查询ASM模板文件的ID：通过查询V$ASM_TEMPLATE视图，可以查询ASM模板文件的ID

6. 查询ASM模板文件的类型和子类型：通过查询V$ASM_TEMPLATE视图，可以查询 ASM模板文件的类型和子类型

7. 查询ASM模板文件的标签：通过查询V$ASM_TEMPLATE视图，可以查询ASM模板文件的标签

官方英文解释

In an Oracle Automatic Storage Management (Oracle ASM) instance, V$ASM_TEMPLATE displays one row for every template present in every disk group mounted by the Oracle ASM instance.

In a database instance, V$ASM_TEMPLATE displays one row for every template present in every disk group mounted by the Oracle ASM instance with which the database instance communicates.

Column	Datatype	Description
`GROUP_NUMBER`	`NUMBER`	Owning disk group number (foreign key to the `V$ASM_DISKGROUP` view)
`ENTRY_NUMBER`	`NUMBER`	Template number (primary key)
`REDUNDANCY`	`VARCHAR2(6)`	Redundancy of the template: `HIGH` `MIRROR` `PARITY` `UNPROT`
`STRIPE`	`VARCHAR2(6)`	Indicates how the template is striped: `FINE` `COARSE`
`SYSTEM`	`VARCHAR2(1)`	Indicates whether the template is a system template (`Y`) or not (`N`)
`NAME`	`VARCHAR2(30)`	Name of the template
`PRIMARY_REGION`^Foot 1	`VARCHAR2(4)`	Region used for allocating primary extents: `HOT` `COLD`
`MIRROR_REGION`^Foot 1	`VARCHAR2(4)`	Region 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.

Note:

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