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.
D and E, agree
D, E
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
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..)
A because DBCPU is under DBTIME
D because of hard parse bind mismatch
D,E