Re: concepts document part about separating indexes and tablspaces

The grinder here is that, "This is not correct" is not correct either. Saying "That is not necessarily correct" would be more correct but I think still not helpful enough.

What you *do* need to separate are "hot" segments--segments that motivate high IOps rates in your system. Absolutely, RAID implementations of striping tend to do that separation for you. I use the word "tend" here on purpose; whether adequate I/O load balancing occurs as a result of striping is a *statistical
*principle.

If you want to make sure you have control over the separation of hot segments (or segments that might someday have high, competing I/O rates), then put them in separate tablespaces.

Cary Millsap
http://method-r.com
http://carymillsap.blogspot.com

On Sat, May 17, 2008 at 3:54 AM, Hemant K Chitale <hkchital_at_singnet.com.sg> wrote:

>
> The 10.2 Performance Tuning Guide, Chapter 8, section 8.2.2
>
> <
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/iodesign.htm#sthref528
> >
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/iodesign.htm#sthref528
>
> does say
> "One popular approach to manual I/O distribution suggests separating a
> frequently used table from its index. This is not correct. "
>
>
> At 02:26 AM Friday, Bobak, Mark wrote:
>
>> If it says that, someone should file a documentation bug to get it fixed.
>>
>> -Mark
>>
>> --
>> Mark J. Bobak
>> Senior Database Administrator, System & Product Technologies
>>
>>
>> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
>> On Behalf Of Rick Ricky
>> Sent: Thursday, May 15, 2008 2:17 PM
>> To: oracle-l_at_freelists.org
>> Subject: concepts document part about separating indexes and tablspaces
>>
>> i was talking to someone about this today. I cannot remember where in the
>> Concepts document that it says that separating data from indexes improves
>> performances?
>>
>
>
> Hemant K Chitale
>
> http://hemantoracledba.blogspot.com
>
> "A 'No' uttered from the deepest conviction is better than a 'Yes' merely
> uttered to please, or worse, to avoid trouble."
> Mohandas Gandhi Quotes :
> http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l