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: SAME config

Re: SAME config

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Tue, 31 Aug 2004 17:09:30 GMT
Message-ID: <eh2Zc.37211$A8.16572@edtnps89>


David E. Grove wrote:

>
> Might someone please clarify what the precise intent of the SAME paper is?
>

An acknowledgement that the 'traditional' administration of Oracle databases by separating segment types and further separating disparate table 'types' to optimize disk-related performance by managing disk-head movement can now be relegated to myth status.

IOW - there is little/no need to put indexes, look-up tables, heavily used transaction tables and so on into different tablespaces, and separate those tablespaces to different disks or disk controllers, *for the purpose of optimizing performance*.

(There are other, valid reasons for such separation, but performance is not one of them.)

/Hans Received on Tue Aug 31 2004 - 12:09:30 CDT

Original text of this message

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