OCP-IZO-053_QUESTION345

QUESTION NO: 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

 

【题目示意】

   此题考查有关于 V$SESSION_LONGOPS的相关知识。

【解析】

   V$SESSION_LONGOPS显示各种运行时间超过6秒的操作的状态，目前这些操作包括许多备份和恢复功能,，统计数据收集，查询执行。

【实验】

1)V$SESSION_LONGOPS可以查询的信息有哪些。

SYS@ENMOEDU > desc V$SESSION_LONGOPS;

 Name                                                  Null?    Type

 ----------------------------------------------------- -------- --------------------

 SID                                                            NUMBER

 SERIAL#                                                        NUMBER

 OPNAME                                                         VARCHAR2(64)

 TARGET                                                         VARCHAR2(64)

 TARGET_DESC                                                    VARCHAR2(32)

 SOFAR                                                          NUMBER

 TOTALWORK                                                      NUMBER

 UNITS                                                          VARCHAR2(32)

 START_TIME                                                     DATE

 LAST_UPDATE_TIME                                               DATE

 TIMESTAMP                                                      DATE

 TIME_REMAINING                                                 NUMBER

 ELAPSED_SECONDS                                                NUMBER

 CONTEXT                                                        NUMBER

 MESSAGE                                                        VARCHAR2(512)

 USERNAME                                                       VARCHAR2(30)

 SQL_ADDRESS                                                    RAW(4)

 SQL_HASH_VALUE                                                 NUMBER

 SQL_ID                                                         VARCHAR2(13)

 SQL_PLAN_HASH_VALUE                                            NUMBER

 SQL_EXEC_START                                                 DATE

 SQL_EXEC_ID                                                    NUMBER

 SQL_PLAN_LINE_ID                                               NUMBER

 SQL_PLAN_OPERATION                                             VARCHAR2(30)

 SQL_PLAN_OPTIONS                                               VARCHAR2(30)

 QCSID                                                          NUMBER

 

2)在RMAN备份时查看备份需要的时间。

SYS@ENMOEDU > SELECT SID, SERIAL#,OPNAME, TIMESTAMP, SOFAR, TOTALWORK from V$SESSION_LONGOPS;

 

       SID    SERIAL# OPNAME                       SOFAR  TOTALWORK                   ---------- ---------------------------------------------------------------- 

        18         15 RMAN: aggregate input         250898     250898              

       142         11 RMAN: aggregate output        169151     169151             

        18         15 RMAN: aggregate output        169151     169151            

        18         15 RMAN: aggregate input         0          250898

        20         13 RMAN: full datafile backup     250240     250240           

        20         13 RMAN: full datafile backup     209868     209868         

        20         13 RMAN: full datafile backup     250240     250240             

        20         13 RMAN: full datafile backup     128692     128692           

 

【小结】

本题考对动态性能视图的理解。 V$SESSION_LONGOPS可以看到备份需要的时间，因此选择E

【答案】 E

 

相关参考

file:///D:/oracle/11g手册_01/server.112/e40402/dynviews_3022.htm#i1415618

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29435844/viewspace-1078465/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29435844/viewspace-1078465/