For a database instance, one row for each disk
group in use whether mounted or not.
V$ASM_FILE No One row for each file in every mounted disk
group.
V$ASM_OPERATION No One row for each executing long-running
operation in the ASM instance.
V$ASM_TEMPLATE Yes One row for each template in each mounted
disk group in the ASM instance. For a database
instance, one row for each template for each
mounted disk group.
V$ASM_CLIENT Yes One row for each database using disk groups
managed by the ASM instance. For a database
instance, one row for the ASM instance if any
ASM files are open.
V$ASM_ALIAS No One row for every alias in every mounted disk
group.
TABLE 4-3 ASM-Related Dynamic Performance Views
104 Oracle Database 11g DBA Handbook
performance views. For example, the dynamic performance view V$DATAFILE shows the actual
filenames within each disk group. Here is an example:
SQL> select file#, name, blocks from v$datafile;
FILE# NAME BLOCKS
---------- ---------------------------------------- ----------
1 +DATA/dw/datafile/system.256.627432971 89600
2 +DATA/dw/datafile/sysaux.257.627432973 77640
3 +DATA/dw/datafile/undotbs1.258.627432975 12800
4 +DATA/dw/datafile/users.259.627432977 640
5 +DATA/dw/datafile/example.265.627433157 12800
6 /u05/oradata/dmarts.dbf 32000
8 /u05/oradata/xport.dbf 38400
7 rows selected.
ASM filenames can be one of six different formats. In the sections that follow, I??™ll give an
overview of the different formats and the context where they can be used??”either as a reference
to an existing file, during a single-file creation operation, or during a multiple-file creation
operation.
Pages:
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205