Database Administration (MOSC)

MOSC Banner

LOB Column segments grow all the time in Oracle 19c

Hello,

when having a table with BLOB or CLOB columns it seams that the related segment is growing all the time causing that the underlying tablespace aquires more disk space from the operating system. The traffic pattern for these effected columns is that quite many rows are inserted per day and all of them have JSON data stored in the BLOB column. After some retention period the old rows are deleted.

Now using DBMS_SPACE.SPACE_USAGE() it reveals that the value for Expired Blocks/Bytes grows very high. In a concrete case we stopped all DML and used a ALTER TABLE theowner.thetable MOVE LOB('LOBCOL') STORE AS (TABLESPACE theTS). This is quite a heave admin operation and requires the rebuild of indexes too.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center