Thanks for the question, A Reader.
Asked: September 12, 2016 - 8:01 pm UTC
Last updated: September 13, 2016 - 2:58 am UTC
Version: 10.2.0.5
Viewed 1000+ times
You Asked
Hi
We have table t and it has clob segment c .
We can measure the size of the clob segment from dba_segments.
Say
on day 1 : size is 0 gb
On day 2: size is 4 gb
on day 3 : we have pre allocated the extents of size 100gb
on day 4: we know table segment size is between 4gb and 104gb , but what is the exact size ? How to get that , using which query
Many thanks
and Connor said...
select sum(dbms_lob.getlength(clob_col))
from my_table
will give you the most accurate information.
(It's not uncommon for people to store this as a column on the table, which is set at clob creation time).
Is this answer out of date? If it is, please let us know via a Comment