Duy, I remember our Oracle DBA saying something about running a job that actually "releases the data".
So even if you delete rows, the space isn't freed up until some job is run. Obviously this isn't a solution but hopefully it points you in the right direction. Tauf Chowdhury Analyst, Service Management Office: 631.858.7765 Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Duy Do Sent: Thursday, January 22, 2009 5:49 PM To: [email protected] Subject: LOB Space Reclaim Procedure Issue ** Hi List, As per a BMC supplied white paper document to reclaim space, we moved LOBs from "Out of Row" to "In Row" which we gained space about 19GB out of 32GB in ARSystem tablespace. After initial testings, the following results were observed Table Name LOB Name Operation Initial Size (MB) Final Size (MB) B876C18004 C18004 Insert 5000 rows 288 288 B876C18004 C18004 Delete 5000 rows 288 288 B876C18004 C18004 Insert 5000 rows 288 360 This shows that Oracle has not re-used the Deleted space during the 2nd Insert. Has anyone encountered a similar problem and know of a resolution. Any help would be greatly appreciated!!! We are running on Oracle Database 10g Release 10.2.0.2.0 - 64bit version on Sun Solaris Version 10, 64 bit Platform. Thank you in advance, Duy Do Broadcast Australia ************************************************************************ ************************************************************************ ******************************* IMPORTANT NOTICE This email and any attachments may be confidential and/or privileged, in which case neither is intended to be waived. If received in error, please contact us and delete all copies. Before opening or using attachments, check them for viruses and defects. Our liability is limited to resupplying any affected attachments. __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ ********************************************************************** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
