 |
|
Oracle Tips by Burleson |
Easy Oracle Automation
Chapter 5 -
Automatic Storage Management
Dynamic Performance Views on ASM
v$asm_operation - has information on
every active long running ASM operation in the ASM instance. In
a database instance, it has no information.
|
Column |
Description |
|
GROUP_NUMBER |
Disk group number - Primary key |
|
OPERATION |
Operation type – REBAL |
|
STATE |
State of the operation - RUNNING,
QUEUED |
|
POWER |
Power requested for the operation |
|
ACTUAL |
Power allocated to the operation |
|
SOFAR |
Number of allocation units moved so
far by the operation |
|
EST_WORK |
Estimated number of allocation
units to be moved by the operation |
|
EST_RATE |
Estimated number of allocation
units being moved per minute by the operation |
|
EST_MINUTES |
Estimated amount of time expected
for the remainder of the operation to complete in
minutes |
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
|
|
