LOB storage usage

From: Reidy, Ron <Ron.Reidy_at_arraybiopharma.com>
Date: Thu, 21 Oct 2004 14:05:28 -0600
Message-ID: <17CAB0BF27BCFC47B0E4554A0E2F962B438F91@fiji.arraybp.com>

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 Received on Thu Oct 21 2004 - 15:00:01 CDT