Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help: free space within a BLOB table
You can use the DBMS_LOB package and use the GETLENGTH parameter to find out
the size of it. I am not sure if this is what you are looking for hope it
helps
susana73_at_hotmail.com wrote in message <8jr0id$5t6$1_at_nnrp1.deja.com>...
>Hi there,
>
>I have a 50GB table which I consistently delete and insert data. I
>would like to check the free space(unused blocks/bytes) within this
>table frequently. However, the blocks, empty_blocks column in
>dba_tables only shows the statistics on table segment, NOT the BLOB
>segment of the table. Anyone know how to get the space statistis on
>BLOB segment?
>
>Thanks in advance!
>
>Susan
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Mon Jul 03 2000 - 00:00:00 CDT
![]() |
![]() |