[progress Communities] [progress Openedge Abl] Forum Post: Re: Excessive Clob Growth

  • Thread starter Thread starter gus
  • Start date Start date
Status
Not open for further replies.
G

gus

Guest
> On Apr 30, 2016, at 7:44 AM, George Potemkin wrote: > > As the database objects the LOB fields are stored in the blocks exactly as the records. You have got the dump of block with dbkey 4416. And it's objectType 3 (LOB). right. George didn't mention that it is /pieces/ of the LOB. Max LOB size is 1 GB. A huge LOB can get chopped into many pieces and span many blocks. Don't forget that creating, updating, and deleting LOBs can generate a lot of transaction log activity.

Continue reading...
 
Status
Not open for further replies.
Back
Top