Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

V$ASM_FILE

In an Automatic Storage Management instance, V$ASM_FILE displays one row for every Automatic Storage Management file in every disk group mounted by the Automatic Storage Management instance. In a database instance, V$ASM_FILE displays no rows.

Column Datatype Description
GROUP_NUMBER NUMBER Number of the disk group containing the file (composite primary key)
FILE_NUMBER NUMBER Number of the file within the disk group (composite primary key)
COMPOUND_INDEX NUMBER A 32-bit number consisting of a disk group number in the high-order 8 bits and a file number in the low-order 24 bits (for efficient access to the view)
INCARNATION NUMBER Incarnation number for the file (composite primary key)
BLOCK_SIZE NUMBER Block size of the file (in bytes)
BLOCKS NUMBER Number of blocks in the file
BYTES NUMBER Number of bytes in the file
SPACE NUMBER Number of bytes allocated to the file
TYPE VARCHAR2(64) Type of the file
REDUNDANCY VARCHAR2(6) Redundancy of the file:
  • UNPROT

  • MIRROR

  • PARITY

STRIPED VARCHAR2(6) Indicates how the file is striped:
  • FINE

  • COARSE

CREATION_DATE DATE Date on which the file was created
MODIFICATION_DATE DATE Date of the last open/close for writing