LOB storage usage

All,

I have a database instance in test right now that will soon be coming on =
line to production.  This instance has ~ 60GB of BLOB data in several =
tables throughout the instance.

I would like to get an idea of the size the LOB segments (both allocated =
and actually used) so I can ensure I am not wasting any disk space.

My environment is:

Oracle 9.2.0.5.0
RedHat 3.0

All tablespaces are locally managed, uniform size of 120k bytes, =
NOCACHE, NOLOGGING; PCTVERSION 10; CHUNK is default (CHUNK may change, =
depending on some use cases the developers are investigating at this =
time).

Thanks for your input.

-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.



This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender  of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.

--
http://www.freelists.org/webpage/oracle-l

Other related posts: