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 |
---|---|---|
|
|
Owning disk group number (foreign key to the |
|
|
Template number (primary key) |
|
|
Redundancy of the template:
|
|
|
Indicates how the template is striped:
|
|
|
Indicates whether the template is a system template ( |
|
|
Name of the template |
|
|
Region used for allocating primary extents:
|
|
|
Region for allocating mirrored extents:
|
|
|
The ID of the container to which the data pertains. Possible values include:
For this view, the value is always |
See Also:
Oracle Automatic Storage Management Administrator's Guide for additional information about using views to display Oracle ASM information