Re: What are the benefits/drawbacks of placing tables into different tablespaces?

If the disks have separate controllers this should help ( not so much if not) - also, the sizing of the tablespace and tables and the storage parameters ( to maximize the use of the cache ) will also add performance....

hth,

PS you might want to check out:
Don Burleson's book - High Performance Oracle8 Tuning from Coriolis Group Books www.coriolis.com

Altho' its is for Oracle 8, the ideas should be adaptable to earlier versions...

"Roger" <NOrgSPAM_at_mcs-hh.de> wrote:

>This is the first step, the next step ist to put this tablespaces on
>different disks...
>
>Roger
>
>jgroff <jgroff_at_msn.com> schrieb in im Newsbeitrag:
>eamVu$3W$GA.262_at_cpmsnbbsa02...
>> We're experiencing some performance problems and we had a consultant
>suggest
>> that we split some of the more heavily accessed/updated tables out into
>> their own dedicated tablespaces.
>>
>> Is this going to buy us anything?
>>
>>
>

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Mon Jan 10 2000 - 11:48:00 CST