Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SAME config
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