LOB segment size is significantly increasing despite of small actual size of data in it
Last updated on NOVEMBER 08, 2017
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 12.1 to 12.2]
Information in this document applies to any platform.
+ A LOB segment is of size around few hundreds of GB when it is actually of around few hundred of MB only.
+ Also, 'enq: TX - contention' wait event is noticed in peak hours on the same LOB.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms