lob space - used and free

From: Kaing, Leng <Leng.Kaing_at_team.telstra.com>
Date: Wed, 12 May 2004 14:26:53 +1000
Message-ID: <778AA0998E7BD411879D0008C7246DF40FB05614@ntmsg0093.corpmail.telstra.com.au>

Hello everyone,

I can't really think straight at the moment - got a cold and just = returned from holidays! So was hoping that you'd help me out...

In our Oracle 8i database we have a table with a BLOB that is frequently = inserted into and deleted from. We're keeping 1 week's data. Physical = size for the lob is currently 14.5G. The LOB is in-row, chunk size is = 8K, db_block_size is 8K , tablespace is 100M uniform allocation.

So how do I find out the actual space usage in this BLOB? How do you = determine its free space? Can it benefinit from a rebuild?=20

TIA, Leng.

Leng Kaing
Email: leng.kaing_at_team.telstra.com
Phone: +61-3-9203-7589
Mobile: +61-417-371-348

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Tue May 11 2004 - 23:24:17 CDT