Oracle Database Administration 2022 Certified Professional — Question 43

Multiple sessions are inserting data concurrently into a table that has an LOB column.
At some point in time, one of the sessions cannot find available space in the LOB segment and needs to allocate a new extent.
Which wait event will be raised in the other sessions that need space in the LOB column?

Answer options

• A. eng: SQ - contention
• B. eng: TM - contention
• C. eng: HW - contention
• D. eng: TX - allocate ITL entry

Correct answer: C

Explanation

The correct answer is C, 'eng: HW - contention', which occurs when there is a wait for space in the LOB segment. Options A, B, and D relate to different types of contention or wait events that do not specifically address the situation of waiting for LOB space allocation.