XI 7.0 large tables that are LOBSEGMENT

[Former Member]

What are LOBSEGMENT tables and how can they be reduced in size? I have three tables that are 8 GB 14 GB and 13.5 in size and need to reduce this.

Thanks

Mikie

[Former Member]

One of the SAP LOBs references a root object XI_AF_MSG.

Assuming that this is the adapter Framework message table is there a job that will schrink this LOB, such as a reorg program or archive object?

And how can I fing the actual tables to remove the data.

Thanks

Mikie

[Former Member]

HI MIke

Its a BRCONNECT issue

These links will help you

http://help.sap.com/saphelp_nw04s/helpdata/en/6e/e8e93a29768802e10000000a11402f/frameset.htm

/people/jim.spath/blog/2007/11/27/unicode--episode-0003-revenge-of-the-space-monster

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/7640c72f-0d01-0010-2787-b39b0ed1...

Check the guide for setting up jobs on unicoded DB issues

Thanks

Gaurav

[Former Member]

Mike-

Did you find the job you need to run to shrink these? We have the same issue....

Thanks. Tracy

[dharamveer_gaur2]

Hi

Read this documentation

There's some information about LOB segments / free space at this Ask Tom thread:

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:14339684180676

This document refers to shrinking LOB segments using ALTER TABLE x SHRINK SPACE compact cascade

http://www.oraclecoach.com/Docs/pdfs/Oracle_10g_Space_Management.pdf

There is a white paper here: http://www.oracle.com/technology/products/database/application_development/pdf/lob_performance_guide...

Read the section on RETENTION and PCTVERSION. If PCTVERSION=100, space allocated for older versions of LOB data won't be reused.

[xinjiang_li]

Hi,

Try to change the value of db parameter:undo_retention

[xinjiang_li]

Hi，

check this link:

/thread/244630 [original link is broken]