Examine the partial AWR report taken for a time period of 60 minutes:
Which two inferences can you draw from this report?(Choose two.)
A.
The database user calls are issuing frequent explicit commits.
B.
The CPUs are busy executing server processes and background processes for a
considerable amount of CPU time.
C.
The database user calls are spending most of their time in I/O for single block reads.
D.
The database user calls are spending most of their time waiting for sessions that are in
more important consumer groups.
I think A,D
B, D
Why B? IT say “background processes” but CPU TIME does not consider background processes.
I would say A,D too.
AD
A : log file sync is generated by user commits
log file sync : When a user session commits, the session’s redo information must be flushed to the redo logfile. The user session will post the LGWR to write the log buffer to the redo log file. When the LGWR has finished writing, it will post the user session.
D :
resmgr:cpu quantum
The session is waiting to be allocated a quantum of cpu. This event occurs when the resource manager is enabled and is throttling CPU consumption. To reduce the occurrence of this wait event, increase the CPU allocation for the sessions’s current consumer group.
Wait Time: The time the session waited to acquire a CPU quantum