RE: Tablespace growing like anything and free blocks not reutilized.
- From: "Powell, Mark" <mark.powell2@xxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 28 May 2010 17:02:48 +0000
Direct loads take their blocks from above the HWM so unless you truncate first
you are not going to get space reuse.
There have been numerous bugs related to ASSM space reuse and you may also be
hitting one of them as mentioned, but direct loads alone could be causing your
issue.
LOB space reuse via transactions is also known to be poor. The new versions of
LOB called Secure Files in 11g is supposed to improve LOB space usage.
Being that you are in test truncating before reloading should be an option
though if you have to reload after only partial deletes you should switch the
sqlldr jobs to using conventional loads. There may be a load performance cost.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Vamshi Damidi
Sent: Friday, May 28, 2010 12:45 PM
To: D'Hooge Freek
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Tablespace growing like anything and free blocks not reutilized.
Mark,
We are using Direct loads.
Freek,
I think we are hitting on this bug.
Thanks,
Vamshi .D
On Fri, May 28, 2010 at 11:29 AM, D'Hooge Freek
<Freek.DHooge@xxxxxxxxx<mailto:Freek.DHooge@xxxxxxxxx>> wrote:
Hi,
I had a client with a similar problem, which turned out to be bug 5987262.
Can you check mos note "Table/Index (partition) Growth Is Far More Than
Expected [ID 729149.1]" to verify if you hit the same bug?
Regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx<mailto:freek.dhooge@xxxxxxxxx>
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer<http://www.uptime.be/disclaimer>
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>] On
Behalf Of Vamshi Damidi
Sent: vrijdag 28 mei 2010 17:18
To: Warren Puziewicz
Cc: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
Subject: Re: Tablespace growing like anything and free blocks not reutilized.
My ETL code doesnt use this option APPEND.
and 50% of time we use SQLLDR to migrate data from mysql to oracle to get old
data.
Thanks,
Vamshi .D
Other related posts:
