RE: Tablespace growing like anything and free blocks not reutilized.
- From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
- To: <dbaprimatics@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 28 May 2010 11:29:13 -0400
There is this bug that I've had, I don't know if it's supposed to be fixed
in 10.2.0.3 or not. Check metalink
CLOB IN ASSM TABLESPACE DOES NOT FREE SPACE AFTER DELETE
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Vamshi Damidi
Sent: Friday, May 28, 2010 11:08 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Tablespace growing like anything and free blocks not reutilized.
Hi All,
I have below problem let me first give you some information.
Environment : DatawareHouse.
Version : 10.2.0.3 Oracle Enterprise all the patches applied.
Blocksize : 16k
Tablespace : extent management local uniform 100m segment management auto.
Disk : Raid 5 of 1tb space with 8 disks.
OS : RHEL 5 .Runnning LVM.
Other related posts:
