Re: concepts document part about separating indexes and tablspaces
- From: "Cary Millsap" <cary.millsap@xxxxxxxxxxxx>
- To: hkchital@xxxxxxxxxxxxxx
- Date: Mon, 19 May 2008 10:39:14 -0500
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@xxxxxxxxxxxxxx>
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
>> On Behalf Of Rick Ricky
>> Sent: Thursday, May 15, 2008 2:17 PM
>> To: oracle-l@xxxxxxxxxxxxx
>> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
