Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Get A Blob size in bytes

592315Sep 15 2009 — edited Sep 16 2009
I am traying to determine the size of a BLOB in a table in bytes , NOT in characters.

I am using Oraclle 9i.

I tried to use dbms_lob.getlenght , this is what happens:

select sum(dbms_lob.getlenght(BLOB COLUMN))/1024/1024/1024 from TAB1.
This returned 2.3G

but when i checked the LOB segment in user_segments (getting the lob segment from user_lobs) i got 44G !!!!

How can it be ? does anyone know what am i missing here ?

I need to figure out which BLOBS in TAB1 are the biggest in terms of bytes but it seems that dbms_lob.getlength and the actual size of the segment are not the same.

Amit Zor

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 14 2009
Added on Sep 15 2009
3 comments
11,798 views