CLOB data appearing too large
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: CLOB data appearing too large

  1. #1
    Join Date
    Mar 2003
    Posts
    29

    CLOB data appearing too large

    Hi.

    I have a table containging a CLOB column,

    when I do as select off the DBA_SEGMENTS view it shows that this table is using up over 3gig worth of space. - but there is only a hundred or so rows in it.
    When I use the DBMS_LOBS.getlength package it tells me that on average my data per row is about 730Kb.

    I know 730Kb is right cause we take data out of this table use it in an web application for users to view over the Internet and there are 1 row for each user about 100. (Data is compressed XML)
    there is no way this app would have worked if the data was really 3 gig - cause you cant download that over the web in reasonable time.

    Are there any bugs in Oracle 8.1.7 with LOBS that could cause this or do i have any storage parameters wrong.
    Or is this simply normal??

    Thanks,

    j

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    Show us your lob & table storage parameters.
    Best wishes!
    Dmitri

Posting Permissions

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



Click Here to Expand Forum to Full Width