OCP-1Z0-053-V12.02-345题
来源:互联网 发布:淘宝美工排版 编辑:程序博客网 时间:2024/06/02 20:56
345.What view might you use to try to determine how long a particular backup will take?
A. V$SESSION_EVENT
B. V$SESSION
C. V$WAITS
D. V$WAITSTAT
E. V$SESSION_LONGOPS
Answer: E
答案解析:
参考如下:
sys@TEST1107> SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,
2 ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"
3 FROM V$SESSION_LONGOPS
4 WHERE OPNAME LIKE 'RMAN%'
5 AND OPNAME NOT LIKE '%aggregate%'
6 AND TOTALWORK != 0
7 AND SOFAR <> TOTALWORK;
SID SERIAL# CONTEXT SOFAR TOTALWORK %_COMPLETE
---------- ---------- ---------- ---------- ---------- ----------
189 7 1 31998 80640 39.68
156 49 1 31870 92800 34.34
V$SESSION_LONGOPS
displays the status of various operations that run for longer than 6 seconds (in absolute time). These operations currently include many backup and recovery functions, statistics gathering, and query execution, and more operations are added for every Oracle release.
To monitor query execution progress, you must be using the cost-based optimizer and you must:
Set the
TIMED_STATISTICS
orSQL_TRACE
parameters totrue
Gather statistics for your objects with the
DBMS_STATS
package
- OCP-1Z0-053-V12.02-345题
- OCP-1Z0-053-V12.02-679题
- OCP-1Z0-053-V12.02-591题
- OCP-1Z0-053-V12.02-590题
- OCP-1Z0-053-V12.02-552题
- OCP-1Z0-053-V12.02-551题
- OCP-1Z0-053-V12.02-549题
- OCP-1Z0-053-V12.02-548题
- OCP-1Z0-053-V12.02-234题
- OCP-1Z0-053-V12.02-584题
- OCP-1Z0-053-V12.02-595题
- OCP-1Z0-053-V12.02-184题
- OCP-1Z0-053-V12.02-59题
- OCP-1Z0-053-V12.02-676题
- OCP-1Z0-053-V12.02-667题
- OCP-1Z0-053-V12.02-660题
- OCP-1Z0-053-V12.02-580题
- OCP-1Z0-053-V12.02-323题
- Core Animation编程指南
- 0x 这样写的意义
- vlc学习计划(5)--网络数据流接收处理过程分析
- vlc学习计划(6)--从接收到数据流到播放视频的过程分析
- 如何在服务器上配置ODBC来访问本机DB2 for Windows服务器
- OCP-1Z0-053-V12.02-345题
- Android 系统Menu样式的修改
- 转载:我常用的 Python 调试工具
- 性能测试项目实施流程
- C++中的声明,定义和赋值几个概念的理解
- 预定义宏与条件编译
- 指针数组与数组指针
- py 正则表达式 List的使用, cxfreeze打包
- 正则表达式-空格 横杠