Which two inferences can be definitely derived from thi…

Examine the Time ModelStatistics section of an AWR report:

Which two inferences can be definitely derived from this section?(Choose two.)

Examine the Time ModelStatistics section of an AWR report:

Which two inferences can be definitely derived from this section?(Choose two.)

A.
The available CPU resources were not utilized to their maximum capacity.

B.
All sequence numbers used during this AWR time interval were cached.

C.
A large number of connected user sessions were idle.

D.
New child cursors were created because of new bind values or usage of literal values as
well as different bind types or sizes.

E.
The DB CPU timewasnot spent exclusively for processing SQL statements.



Leave a Reply 6

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


vasya

vasya

D and E, agree

dmx

dmx

in the exam I unfortunately chose D,E. I think that I made a mistake by choosing the option “D”:(

imo B,E…

D is wrong. “hard parse (bind mismatch) elapsed time” – does not increment if we use SQL with literal values

job

job

D,E

B is wrong, definetely all nextvals were not cached when theres time spent there.
D. is correct: the use of literals will just produce a different cursor statement altogether, therefore a hard parse (theres other time statistics regarding hard parses above not just the bind variable one..)

Fonx

Fonx

A because DBCPU is under DBTIME
D because of hard parse bind mismatch