which three situations doesDB timealways increase?

In which three situations doesDB timealways increase?(Choose three.)

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)



Leave a Reply 4

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


vasya

vasya

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.

carlosegf

carlosegf

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