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:arsl...@arslist.org] On Behalf Of Duy Do
Sent: Thursday, January 22, 2009 5:49 PM
To: arslist@ARSLIST.ORG
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"
