Useful SQL Statements to Check What Makes FND_LOBS Grow? (Doc ID 1245974.1)
How to Find Lengtht of the Attachments Uploaded of Documents of Record? (Doc ID 1580234.1)
How To Determine The Size of a File In Table FND_LOBS? (Doc ID 401094.1)
How To Purge FND_LOBS? (Doc ID 871721.1)
How To Manage, Reduce, and/or Purged The FND_LOBS Table? (Doc ID 1288149.1)
Also search MOS for FND_LOBS and/or FND_ATTACHED_DOCUMENTS and you should get many hits.
Thanks a lot Hussein. this really helps. Ignore my other posting as it didn't submit first time and I did the second time and it got duplicated