Seeking Advice on Oracle EBS Table Growth – LOB and Index Size Concerns, EBS R12.2.10 , Performance
Hi Oracle Community,
I’m seeking guidance on the growth trends of certain Oracle EBS tables in our environment. We’ve noticed substantial space usage, particularly in LOB segments and indexes, and would appreciate your insights on managing this growth effectively.
Here’s a snapshot of some of the largest tables:
OWNER | TABLE_NAME | TOTAL_GB | TABLE_GB | INDEXES_GB | LOB_GB | LOBINDEXES_GB |
|---|---|---|---|---|---|---|
APPLSYS | FND_LOBS | 3223.47 | 2.12 | 0.95 | 3215.85 | 4.56 |
Q: Is such a high LOB size (3215.85 GB) typical for
FND_LOBSin EBS environments? What strategies are recommended to analyze and manage this growth?
| XLA | XLA_DISTRIBUTION_LINKS | 520.72 | 330.25 | 190.47 | 0 | 0 | | XLA | XLA_AE_LINES | 358.97 | 222.61 | 136.36 | 0 | 0 |
0