(Choose three.)

View the Exhibit and examine a portion of the output obtained from the following query:

SQL> SELECT * FROM v$sys_time_model;
Select three correct interpretations of the time model statistics. (Choose three.)

View the Exhibit and examine a portion of the output obtained from the following query:

SQL> SELECT * FROM v$sys_time_model;
Select three correct interpretations of the time model statistics. (Choose three.)

A.
DB time includes the wait time of all the nonidle and idle user sessions.

B.
SQL execute elapsed time includes the time spent in performing fetches of query results.

C.
DB CPU includes the CPU time spent on database user-level calls and background CPU time.

D.
SQL execute elapsed time includes components of the hard parse elapsed time like bind
elapsed time.

E.
DB time includes the connection management call elapsed time excluding the background
process time.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

A is wrong. DB time does not include idle time
B is right. for select, it includes fetching result
C is wrong. no background process time
D is right.
E is right.

So B.D.E. are correct