Re: Performance issue after creating higher block size tablespace - a further question
- From: Jared Still <jkstill@xxxxxxxxx>
- To: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- Date: Mon, 1 Mar 2010 08:29:55 -0800
Personally, I no longer find this interesting, but simply tiresome.
It has long since been shown that these results were due to a bug.
Sorry, can't remember the details, and not really interested in
digging them up.
Anyone that feels like tweaking block sizes as a tuning method
is free to do so, though for the life of me I can't see why when
these results are found that the individual investigating it would
not dig down the the real reason for the results.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
On Mon, Mar 1, 2010 at 8:00 AM, Andrew Kerber <andrew.kerber@xxxxxxxxx>wrote:
> The Oracle Alchemist has an interesting blog on this topic:
>
> http://www.oraclealchemist.com/oracle/hey-guys-does-size-matter/
>
>
>
>
> On Mon, Mar 1, 2010 at 9:53 AM, Jared Still <jkstill@xxxxxxxxx> wrote:
>
>> On Mon, Mar 1, 2010 at 7:30 AM, Saad Khan <saad4u@xxxxxxxxx> wrote:
>>
>>>
>>> But that has done some reorg but I dont think that will resolve the
>>> original performance issue. The "do something" song is still being drummed
>>> on my head.
>>>
>>>
>> I can't recall from the original thread:
>>
>> Has this operation been traced?
>>
>> Do you know where it is spending time?
>>
>> If you don't know where the time is going, you can't fix the problem.
>>
>>
>> Jared Still
>> Certifiable Oracle DBA and Part Time Perl Evangelist
>> Oracle Blog: http://jkstill.blogspot.com
>> Home Page: http://jaredstill.com
>>
>>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>
Other related posts:
