My Oracle Support Banner

FAQ - Performance Considerations For FND_LOBS (Doc ID 829235.1)

Last updated on DECEMBER 04, 2023

Applies to:

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

Purpose

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
Purpose
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?

References

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