| Schema size is very large - LOBSEGMENT [message #392025] |
Mon, 16 March 2009 01:30  |
ivpraveen
Messages: 5
Registered: March 2009
|
Junior Member |
|
|
There is schema whose size is increased exponentially, I've found that there is one segment of size 31.75 GB and has only one table whose size is 57M. That table has two column of BLOB type. Could you please help me out, how to reduce the size of segment? how to proceed.
Storage Clause of that table: -
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "ASH"
LOB ("IN_REM") STORE AS (
TABLESPACE "ASH" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10
NOCACHE
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))
LOB ("OUT_REM") STORE AS (
TABLESPACE "ASH" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10
NOCACHE
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
