Hi all,

The table in question has 4 fields:
UNID 19 chars
DATA 2147483647 (BLOB)
ROW 19 chars
DT 10 chars

Second column can take upto 2GB (attachments etc). So I am trying to figure out the growth of these attachments in the database in terms of space.

But the actual value in this column in not the attachment itself but a pointer/descriptor to this attachment stored somewhere on disk.

So when you estimate the size of the table it doesn't include the attachments size. It just estimates the size using the average size of the 3 fields plus the average size of the pointer.

So where are these LOB's stored on disk (I mean is it in the same tablespace) if so how do we estimate the growth of these attachments (as the tablespace has several other tables).

Thanks in advance

How about using the LENGTH function?

Andy

Try the table snapshot; it shows data, lob, and index utilization separately, if I'm not mistaken.