My Oracle Support Banner

FAQ - Performance Considerations For FND_LOBS (Doc ID 829235.1)

Last updated on MARCH 19, 2022

Applies to:

Oracle E-Business Suite Performance - Version to 12.1.3 [Release 11.5.10 to 12.1]
Oracle Application Object Library - Version to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.


E-Business Suite Applications Performance related issues




Provide guidance when dealing with FND_LOBS table size and performance related issues.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Questions and Answers
 What is stored in FND_LOBS?
 How to speed up index creation in FND_LOBS_CTX?
 How to purge entries from FND_LOBS?
 How to reclaim space in FND_LOBS?
 How to find the space allocated in the lobsegments versus used space?
 How to find the space used by each program? 
 How to size the storage parameters for FND_LOBS?
 How to prevent huge files to be uploaded to FND_LOBS?
 How to see contents of the LOB?


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.