In which three situations doesDB timealways increase?(Choose three.)
A.
when the host is CPU bound for foreground processes
B.
when I/O wait time increases for foreground processes
C.
when more connections are made to a database instance
D.
when CPU consumption by background processes increases
E.
when wait time for data to be sent over a network increases
Explanation:
http://www.oracle.com/technetwork/oem/db-mgmt/s317294-db-perf-tuning-with- db-time-
181631.pdf(page 21)
D – wrong as background processed resource comsuptions are not included in DB Time
E – seems okay, as it is data transferring non-idle wait. I hope E doesn’t mean “SQL*Net message to client” event, if so then E is incorrect.
A,B,C
BCE
ABC
DB TIME is the sum of the time sessions spend in user calls.
D – DB TIME doesn’t include waits by background process
E – DB TIME doesn’t include waits by network