Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What are the benefits/drawbacks of placing tables into different tablespaces?

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

From: jgroff <jgroff_at_msn.com>
Date: Tue, 11 Jan 2000 08:32:59 -0500
Message-ID: <eLtIHkDX$GA.252@cpmsnbbsa03>


So the only benefit you can get from splitting tables into seperate table spaces is the ability to place them on different devices?

dave mausner wrote in message <8EB88EA7dlm_at_206.141.192.241>...
>NOrgSPAM_at_mcs-hh.de (Roger) wrote in
><85d5cu$u3s$1_at_opal.hamburg.cityline.net>:
>
>>This is the first step, the next step ist to put this tablespaces on
>>different disks...
>>
>>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.
>
>... provided that the disks are not part of the same raid-5 set.
>--
>dave mausner
Received on Tue Jan 11 2000 - 07:32:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US