Database Administration (MOSC)

MOSC Banner

BASIC LOBS Storage parameters - 19C


Hello

We have inherited a 19c database where we have a table that is 1 TB in size with one BLOB data type 

The size of table is a little over 1 TB with 1TB being used by that LOB column

The LOB COLUMN is IMAGE_RECORD and is created as BASIC LOB (instead of SECURE FILE)

Here is the storage setting

LOB (IMAGE_RECORD) STORE AS BASICFILE (

 TABLESPACE APP_LOBS_T

 ENABLE   STORAGE IN ROW

 CHUNK    32768

 RETENTION

 NOCACHE

 LOGGING

 STORAGE  (

       INITIAL     160K

       NEXT       1M

       MINEXTENTS    1

       MAXEXTENTS    UNLIMITED

       PCTINCREASE   0

       BUFFER_POOL   DEFAULT


Quering DBA_EXTENTS and DBA_SEGMENTS we confirmed that there are 18,409 extents in this LOB Segment

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