Last updated on JULY 19, 2017
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
- High "direct path read" wait events during LOB segment access causes slow application
10046 trace shows LOBREAD before the FETCH operation of the concerned cursor:
10046 trace shows the cursor number as 0 for the waits pertaining to LOB (WAIT #0).
Thus TKPROF output does not show related 'direct path read' wait event reported under the SQL statement section that has made the LOB read,rather it would be reported under 'Overall Totals' section. Also 1 block was read conventionally and the wait event was 'db file sequential read'. This is LOB Index block.
Column Data type was changed to LOBs as part of application migration.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms