|
|
| |
 |
|
Oracle Tips by Burleson |
Easy Oracle Automation
Chapter 5 -
Automatic Storage Management
Dynamic Performance Views on ASM
|
Column |
Description |
|
GROUP_NUMBER |
Number of the disk group containing
the file |
|
FILE_NUMBER |
Number of the file within the disk
group |
|
COMPOUND_INDEX |
32-bit number consisting of disk
group number and file number |
|
INCARNATION |
Incarnation number for the file |
|
BLOCK_SIZE |
File block size in bytes |
|
BLOCKS |
Number of blocks in the file |
|
BYTES |
Number of bytes in the file |
|
SPACE |
Space in bytes allocated to the
file |
|
TYPE |
File type |
|
REDUNDANCY |
Redundancy of the file - MIRROR,
PARITY, UNPROT |
|
STRIPED |
Type of file striping - FINE,
COARSE |
|
CREATION_DATE |
File creation date |
|
MODIFICATION_DATE |
Last open/close date for writing |
The above text is
an excerpt from:
Easy Oracle Automation
Oracle10g Automatic
Storage, Memory and Diagnostic Features
ISBN 0-9745993-6-0
by Dr. Arun Kumar R.
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
|
|
