Oracle 视图 V$ASM_OPERATION 官方解释,作用,如何使用详细说明
Oracle视图V$ASM_OPERATION用于查看ASM实例正在进行的操作以及各个操作的进度状态,使用该视图可以查看ASM状态,支持异步I/O、数据拷贝等等操作,包括更新状态、完成状态等等。
使用方法:
SELECT * FROM V$ASM_OPERATION;
该语句可以查询ASM当前正在进行中的操作类型以及操作的当前进度状态。
官方英文解释In an Oracle Automatic Storage Management (Oracle ASM) instance, V$ASM_OPERATION displays one row for every active Oracle ASM long running operation executing in the Oracle ASM instance.
Disk group number (primary key). This is the foreign key to the V$ASM_DISKGROUP view.
Starting with Oracle Database 12c, new queries should use the PASS column instead of this column.
COMPACT Oracle ASM is moving user data closer together, which improves performance by reducing seek distance
PREPARE Completing work corresponding to the prepare SQL operation. This phase is enabled only for FLEX or EXTENDED redundancy disk groups and COMPATIBLE.ASM must be set to 12.2 or higher.
REBUILD Restoring the redundancy of forcing disks. Forcing disks are those disks that have been dropped with the FORCE option.
RESILVER This value appears in Oracle Exadata environments when WriteBack FlashCache is enabled
RESYNC Resync operation in progress to bring one or more Oracle ASM disks online
Starting with Oracle Database 12c, new queries should use this column instead of the OPERATION column.
Estimates are computed in parallel in the background while the work is being executed. Thus, the transition from the EST to the RUN state may be extremely fast.
Power requested for the operation as specified by the ASM_POWER_LIMIT initialization parameter or command syntax. Or, power requested for the operation as specified by the power option of the scrubbing SQL syntax.
Number of Allocation Units that are being moved per minute by the operation. Or, the number of Allocation Units that have been scrubbed so far.
Estimated number of Allocation Units that have to be moved by the operation. Or, the estimated number of Allocation Units that have to be scrubbed by the scrubbing operation.
Estimated number of Allocation Units that are being moved per minute by the operation
Estimated amount of time (in minutes) that the remainder of the operation is expected to take
0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.
Oracle Automatic Storage
Management Administrator s Guide for additional information about using views to display Oracle ASM information
我想要获取技术服务或软件
服务范围:MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式:远程服务、电话支持、现场服务,沟通指定方式服务
技术标签:数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题
本站部分文章参考或来源于网络,如有侵权请联系站长。
数据库远程运维 Oracle 视图 V$ASM_OPERATION 官方解释,作用,如何使用详细说明
相关文章
- Oracle 视图 ALL_ANALYTIC_VIEW_MEAS_CLS 官方解释,作用,如何使用详细说明
- Oracle 视图 ALL_XTERNAL_TAB_SUBPARTITIONS 官方解释,作用,如何使用详细说明
- Oracle 视图 DBA_ROLLING_EVENTS 官方解释,作用,如何使用详细说明
- Oracle 视图 DBA_RULE_SET_RULES 官方解释,作用,如何使用详细说明
- Oracle 视图 DBA_SOURCE_AE 官方解释,作用,如何使用详细说明
- 韩顺平:坚持走向Oracle专家之路(韩顺平oracle)
- 数据库Java实现Oracle数据库监控(java监听oracle)
- 如何使用Oracle创建新的实例(oracle新建实例)
- Oracle使用Concat函数拼接两个字段(oracle拼接两个字段)
- Oracle 数据库备份与归档最佳实践指南(oracle备份归档)
- Oracle 查询表定义的精彩之旅(oracle查询表定义)
- 探秘Oracle虚拟机:强大的虚拟化技术解析(oracle的虚拟机)
- 关闭重启Oracle完整的步骤指南(oracle关闭重启步骤)
- Oracle冷备极致保障数据库可靠性升级(oracle冷备数据库)
- MPP与Oracle数据库技术上的区别(mpp和oracle区别)
- 使用EF4实现C轻松连接Oracle数据库(ef4连接oracle)
- 中间接入从零开始使用Oracle数据库(oracle从0开始还是)
- 利用Oracle事务回滚命令实现数据安全(oracle事物回滚命令)
- 如何在Oracle中停止一个Job(oracle中停止job)
- 顺利完成Oracle一体机安装(oracle一体机安装)
- 号Oracle数据库实例的DG端口号使用说明(oracle dg端口)