Home » RDBMS Server » Server Administration » Schema size is very large - LOBSEGMENT (10.2.0.1.0, Linux)
Schema size is very large - LOBSEGMENT [message #392025] Mon, 16 March 2009 01:30 Go to next message
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
Re: Schema size is very large - LOBSEGMENT [message #392377 is a reply to message #392025] Tue, 17 March 2009 12:58 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Are you sure it is these lob segments that eat up all the space?
Historically, does the table as lots of deletes?
YOu can shrink just a log segment.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/schema.htm#CBBBIADA
Previous Topic: Change the database characterset from WE8ISO8859P1 to AL32UTF8.
Next Topic: Tracking Database Links
Goto Forum:
  


Current Time: Wed Dec 07 14:26:47 CST 2016

Total time taken to generate the page: 0.21443 seconds