Which two statements are true?

Examine the query and its output:

Which two statements are true?(Choose two.)

Examine the query and its output:

Which two statements are true?(Choose two.)

A.
Session 2832 had to wait 2029 seconds for a message to arrive because of a network
bottleneck.

B.
Session 4208 is either idle or experiencing poor response time due to a network or
resource bottleneck on the client process.

C.
Session 3346 is in wait state because it wants to lock a row in a block in which other
sessions have already locked rows, and there is no free ITL slot available in this block.

D.
Session 3346 is in wait state because either it is waiting to update a row that is locked by
another session or another session is trying to insert the same key value in aUNIQUEindex.

E.
Session 4208 is definitely idle and should be killed to free network resources.



Leave a Reply 6

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


Dave

Dave

it’s B and D
C is wrong because the Event would be enq: TX – allocate ITL entry
D is right because the Event says enq: TX – row lock contention

Fonx

Fonx

BD ok, why not