Oracle Exam 1Z0-084 Topic 7 Question 8 Discussion

Actual exam question for Oracle's 1Z0-084 exam

Question #: 8
Topic #: 7

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?

Aenq: SQ - contention

Benq: TM - contention

Cenq: HW - contention

Denq: TX - allocate ITL entry

Show Suggested Answer

Suggested Answer: C

When sessions concurrently insert data into a table with an LOB column and one session needs to allocate a new extent because it cannot find available space, the wait event associated with this contention is 'enq: HW - contention'. The HW stands for High Water Mark which is related to space allocation in the database segment. When a session needs to allocate a new extent, it may raise this wait event in other sessions that are also attempting to allocate space in the same LOB segment.

Reference

Oracle Database 19c Reference Guide - enq: HW - contention

by Delbert at Apr 29, 2024, 02:57 PM

Limited Time Offer

25%

7 months ago

Did you guys see that tricky LOB allocation question in the exam?

upvoted 0 times

...