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