Which condition triggered it?

Real-Time ADDM detects a high-load performance issue within the database. Which condition
triggered it?

A.
The average active sessions were more than three times the number of CPU cores.

B.
Active sessions were more than 10% of total load and CPU utilization was more than 50%.

C.
Memory allocations were more than 95% of physical memory.

D.
Hung sessions were more than 10% of total sessions.

E.
A deadlock was detected.

F.
The session limit was close to 100%.

Explanation:
Reference:
http://docs.oracle.com/cd/E16655_01/server.121/e15857/pfgrf_diag.htm#TGDBA95369 (table 7-1)

Show Hint

← Previous question

Next question →

Leave a Reply 4

Prateek

Option : A

Explanation : Slide 34

https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=3&cad=rja&uact=8&ved=0CCsQFjAC&url=https%3A%2F%2Foraclecn.activeevents.com%2Fconnect%2FfileDownload%2Fsession%2FE33C3860FC71A42A95D55FFDDF273EFE%2FCON1587_Chatterjee.pptx&ei=F3o9Vb30McaogwTi3oGoAQ&usg=AFQjCNEprBRst897OhwW7NW4sFsikbOjYw&sig2=ihHrI9DWdGlQTreGyhJSkA&bvm=bv.91665533,d.eXY

Reply

Prateek

A

http://docs.oracle.com/cd/E16655_01/server.121/e15857/pfgrf_diag.htm#TGDBA95369 (table 7-1)

Below table lists the issues and conditions that trigger a Real-Time ADDM analysis.

Issue Condition
High load Average active sessions are greater than 3 times the number of CPU cores
I/O bound I/O impact on active sessions based on single block read performance
CPU bound Active sessions are greater than 10% of total load and CPU utilization is greater than 50%
Over-allocated memory Memory allocations are over 95% of physical memory
Interconnect bound Based on single block interconnect transfer time
Session limit Session limit is close to 100%
Process limit Process limit is close to 100%
Hung session Hung sessions are greater than 10% of total sessions
Deadlock detected Any deadlock is detected

Reply