Oracle 视图 V$AW_LONGOPS 官方解释,作用,如何使用详细说明
本站中文解释
:
Oracle视图V$AW_LONGOPS用于监控长操作进程(即长时间运行的操作)。它可以帮助查看后台活动的持续时间和所完成的速度。
用法:
1、查看所有长期操作:SELECT * FROM V$AW_LONGOPS;
2、查看具体用户的某个长期操作:SELECT * FROM V$AW_LONGOPS WHERE USERNAME = ‘YOURUSER’ AND OPNAME = ‘SOMETASK’;
3、在需要的时候可以查看某个操作的进度:SELECT PERCENT_COMPLETE FROM V$AW_LONGOPS WHERE OPNAME = ‘SOMETASK’;
4、查看某个操作的可能存在的问题:SELECT ERROR# FROM V$AW_LONGOPS WHERE OPNAME = ‘SOMETASK’;
使用视图V$AW_LONGOPS可以有效地监控正在进行的长期操作进程,并且可以获取各种实时信息,从而调整用户和应用管理策略,实现数据库的有效管理和使用。
官方英文解释
V$AW_LONGOPS
displays status information about active SQL cursors initiated in an analytic workspace.
Column | Datatype | Description |
---|---|---|
|
|
Identifier for the session in which the fetch is executing. This table can be joined with |
|
|
Name assigned to the cursor |
|
|
Command that is actively fetching data from relational tables:
|
|
|
Status of the current operation:
|
|
|
Number of rows already inserted, updated, or deleted |
|
|
Sequence number in the Cube Build log |
|
|
SQL ID of the statement |
|
|
Operated object name |
|
|
A brief description of the operated object |
|
|
Time the command started executing |
|
|
Last updated time |
|
|
Number of seconds between |
|
|
Number of units so far |
|
|
Total number of units |
|
|
Units description:
|
|
|
Message for the user |
|
|
User name |
|
|
The ID of the container to which the data pertains. Possible values include:
|