Home > Workload Solutions > Oracle > White Papers > Oracle ASM on ScaleIO Best Practices > OPERATION11
Table 24 includes compatibility information for the operation11.sql script.
Table 24. Script details—operation11.sql
Type of information |
Details |
Name |
operation11.sql |
Compatibility |
11g, 12c |
Purpose |
Shows currently running operations in ASM. |
Sample output:
SQL> @operation11
DISKGROUP_NAME OPERATION STATE PWR ACTUAL PCT_DONE EST_MIN ERROR_CODE
--------------- -------------------- -------- ---- ------- -------- ------- ------
DATA REBAL RUN 6 6 5.1% 1
Table 25 contains the key to the output.
Table 25. Key to operation11.sql columns
Column |
Meaning |
DISKGROUP_NAME |
Diskgroup name |
OPERATION |
Sector size in bytes |
STATE |
Current state of the operation |
PWR |
Requested power level |
PCT_DONE |
Estimated percentage complete |
EST_MIN |
Estimated minutes to completion |
ERROR_CODE |
Any error codes reported while performing the operation |
Script text:
set linesize 132
set pagesize 999
col diskgroup_name for a15
col gn for 99
col operation for a20
col state for a8
col pwr for 999
col actual for 999999
col sofar for 999999
col est_work for 999999
col est_min for 999999
col pct_done for a8
col error_code for a10
select
vag.name "DISKGROUP_NAME",
-- vao.group_number "GN",
vao.operation,
vao.state,
vao.power "PWR",
vao.actual,
lpad(to_char(100*(vao.sofar/vao.est_work),'999.9')||'%',8) "PCT_DONE",
-- vao.sofar,
-- vao.est_work,
vao.est_minutes "EST_MIN",
vao.error_code
from
v$asm_operation vao,
v$asm_diskgroup vag
where 1=1
and vag.group_number = vao.group_number
/