TAS Information Views
This chapter describes how to view TAS information by using dynamic views.
TAS Disk Space Related Views
The following views can be used to display TAS disk space information.
These views can only be used in TAS instances.
V$AS_ALIAS
All aliases in the disk space mounted by a TAS instance.
V$AS_DISK
All disks discovered by a TAS instance.
V$AS_DISKSPACE
All disk spaces discovered by a TAS instance.
V$AS_OPERATION
All jobs that are being processed in all disk spaces mounted by a TAS
instance.
V$AS_EXTENT_MAP
Physical location of all extents managed by a TAS instance.
V$AS_FILE
All files in all disk spaces mounted by a TAS instance.
When using V$AS_* views, the disk space number may have been changed. This is because a disk space number is given when a disk space is mounted.
V$AS_ALIAS
V$AS_ALIAS view displays all aliases in the disk space mounted by a TAS instance.
NAME
VARCHAR(48)
Alias.
DISKSPACE_NUMBER
NUMBER
Disk space number included in the alias.
FILE_NUMBER
NUMBER
File number of the alias.
FILE_INCARNATION
NUMBER
File incarnation number of the alias.
ALIAS_INCARNATION
NUMBER
Incarnation number of the alias.
V$AS_DISK
V$AS_DISK view displays all disks discovered by a TAS instance.
DISKSPACE_NUMBER
NUMBER
Disk space number that contains the disk.
DISK_NUMBER
NUMBER
Disk number in the disk space.
STATE
VARCHAR(16)
Disk status in the disk space.
ONLINE: Disk is in use.
NOT_USED: Disk is not used in the disk space. The DISKSPACE_NUMBER is displayed as 255.
PREPARE_ADD: Disk is to be added to the disk space. The disk cannot be used until rebalancing starts.
PREPARE_DROP: Disk is to be dropped from the disk space. The disk can be used until rebalancing is complete.
PREPARE_FORCE: Disk is to be removed. The disk cannot be used during rebalancing.
ADDING: Disk is currently being added through rebalancing.
DROPPING: Disk is currently being dropped through rebalancing.
FORCING: Disk is currently being dropped without offloading its data.
SYNC: Synchronization is in progress for changes that could not be applied due to a temporary disk failure.
FAIL: An error has occurred on the disk or the disk has been forcibly taken offline.
OS_MB
NUMBER
Size of the disk recognized by the OS.
TOTAL_MB
NUMBER
Disk size.
FREE_MB
NUMBER
Available disk space.
NAME
VARCHAR(48)
Disk name.
FAILGROUP
VARCHAR(48)
Failure group name that contains the disk.
PATH
VARCHAR(256)
Disk path.
CREATE_DATE
DATE
Date at which the disk was added to the disk space.
V$AS_DISKSPACE
V$AS_DISKSPACE view displays all disk spaces discovered by the TAS instance.
DISKSPACE_NUMBER
NUMBER
Number given in the disk space.
NAME
VARCHAR(48)
Disk space name.
SECTOR_SIZE
NUMBER
Physical block size. (Unit: byte)
BLOCK_SIZE
NUMBER
TAS metadata block size. (Unit: byte)
ALLOCATION_UNIT_SIZE
NUMBER
Allocation unit size. (Unit: byte)
STATE
VARCHAR(16)
Disk space state in the TAS instance.
MOUNTING: Disk space is currently being mounted.
CREATING: Disk space is being created.
MOUNT: Disk space has been mounted.
TYPE
VARCHAR(8)
Disk space redundancy level.
EXTERN: User files are not mirrored.
NORMAL: User files are two-way mirrored across 2 or more failgroups.
HIGH: User files are three-way mirrored across 3 or more failgroups.
TOTAL_MB
NUMBER
Disk space size.
FREE_MB
NUMBER
Size of available disk space.
REQUIRED_MIRROR_FREE_MB
NUMBER
Extra disk space used for disk failures.
USABLE_FILE_MB
NUMBER
Size of available disk space adjusted for mirroring.
V$AS_OPERATION
V$AS_OPERATION view can display all jobs that are being processed in all disk spaces mounted by a TAS instance.
DISKSPACE_NUMBER
NUMBER
Disk space number.
OPERATION
VARCHAR(16)
Job type in progress.
REBALANCE: Rebalancing is in progress.
SYNC: Synchronization is in progress for failed disk(s).
SCRUB: File scrubbing is in progress.
STATE
VARCHAR(8)
Current job state. Since this view displays a job in
progress, the job state is always RUN.
POWER
NUMBER
Power of the operation. Configuring it is not supported currently. (Default value: 10)
JOB_DONE
NUMBER
Number of extents completed.
JOB_REMAIN
NUMBER
Number of extents remained.
JOB_TOTAL
NUMBER
Total number of extents of the job.
EST_SPEED
NUMBER
Estimated job speed. (Unit: extents/second)
EST_REMAIN_TIME
VARCHAR(32)
Estimated time required to complete the job. (Unit: seconds)
The following example displays the rebalancing job that is being processed in the disk space ds0 by using V$AS_OPERATION.
[Example 1] Viewing Jobs in Progress
SQL> SELECT diskspace_number, operation, job_remain, est_remain_time
FROM V$AS_OPERATION;
DISKSPACE_NUMBER OPERATION JOB_REMAIN EST_REMAIN_TIME
----------------- ---------- ----------- ----------------
0 REBALANCE 72 30.6
1 row selected.V$AS_EXTENT_MAP
V$AS_EXTENT_MAP view displays the physical location of all extents managed by a TAS instance.
DISKSPACE_NUMBER
NUMBER
Disk space number to which the file belongs.
FILE_NUMBER
NUMBER
File number in the disk space.
EXTENT_NUMBER
NUMBER
Extent number in the file.
REDUN_NUMBER
NUMBER
Redundancy number of the extent.
EXTENT_SIZE
NUMBER
Extent size. (Unit: AU)
DISK_NUMBER
NUMBER
Number of the disk that saves the extent.
AU_NUMBER
NUMBER
AU number of the extent in the disk.
V$AS_FILE
V$AS_FILE view displays all files in the disk space mounted by a TAS instance.
DISKSPACE_NUMBER
NUMBER
Disk space number to which the file belongs.
FILE_NUMBER
NUMBER
File number in the disk space.
INCARNATION
NUMBER
File incarnation number.
BLOCK_SIZE
NUMBER
File block size. (Unit: bytes)
BYTES
NUMBER
File size. (Unit: bytes)
TYPE
VARCHAR(8)
File type.
DATA: General data file.
CTRL: Control file.
CM: CM file.
REDO: Redo log file.
ARCH: Archive log file.
TEMP: Temporary file.
REDUNDANCY
VARCHAR(8)
File redundancy level.
EXTERN: Files are not mirrored.
NORMAL: Files are two-way mirrored across 2 or more failgroups.
HIGH: Files are three-way mirrored across 3 or more failgroups.
STRIPED
VARCHAR(8)
Striping type.
COARSE: Files are striped in AU size units.
FINE: Files are striped in 1/8 * AU size units.
The following is an example of displaying the alias, number, and size of all files in a disk space by using V$AS_ALIAS and V$AS_DISK.
[Example 2] Viewing Files and Aliases
SQL> SELECT name, a.file_number, bytes
FROM V$AS_ALIAS a, V$AS_FILE f
WHERE a.file_number = f.file_number
AND a.diskspace_number = f.diskspace_number;
NAME FILE_NUMBER BYTES
----------------- ---------------- -------------
c1.ctl 256 3145728
log001.log 257 52428800
log002.log 258 52428800
log003.log 259 52428800
system001.dtf 266 52428800
undo001.dtf 267 85983232
temp001.dtf 268 2097152
usr001.dtf 269 2097152
8 rows selected.Last updated