V$ASM_TEMPLATE

7.67 V$ASM_TEMPLATE

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: `UNPROT` `MIRROR` `HIGH`
`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`	`VARCHAR2(4)`	Region used for allocating primary extents: `HOT` `COLD`
`MIRROR_REGION`	`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`.