Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2006

    Unanswered: Estimating size of a table with LOB column

    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

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    How about using the LENGTH function?


  3. #3
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    Try the table snapshot; it shows data, lob, and index utilization separately, if I'm not mistaken.
    "It does not work" is not a valid problem statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts