Re: Release space used by empty BLOB segments
Date: Mon, 10 Oct 2011 16:31:28 +0300
Message-ID: <OF257ED9E8.63264BB3-ONC2257925.004A042F-C2257925.004A4B18_at_seb.lt>
do you have Tanel Poder's paper on LOB's ?
http://www.slideshare.net/tanelp/oracle-lob-internals-and-performance-tuning
On the other hand indexes never tend to release space unless rebuild/shrink is executed specifically.
Please consider the environment before printing this e-mail
From: Yechiel Adar <adar666_at_inter.net.il>
To: ORACLE-L <oracle-l_at_freelists.org>
Date: 2011.10.10 15:18
Subject: Release space used by empty BLOB segments
I have a partitioned (by week) table that holds data and images.
The data is kept for 7 years (banking) while the images are kept only
for one year.
The images are deleted by updating the fields to empty blobs.
The tables has local indexes and a bunch of global indexes.
The problem is that the empty blob segments are not released after their
content id deleted.
- How can I release the unused space without making the global indexes unusable?
- Preferably while the users are working (but this not a must)?
BANNER
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for Linux: Version 10.2.0.3.0 - Production NLSRTL Version 10.2.0.3.0 - Production
--
Yechiel Adar
Israel
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 10 2011 - 08:31:28 CDT