V$ASM_TEMPLATE

In an Automatic Storage Management instance, V$ASM_TEMPLATE displays one row for every template present in every disk group mounted by the Automatic Storage Management instance. In a database instance, V$ASM_TEMPLATE displays one row for every template present in every disk group mounted by the Automatic Storage Management 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

  • PARITY

  • 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