RE: Optimal Distribution of Datafiles

From: Pablo ksksksk <p_rodri99_at_yahoo.es>
Date: Fri, 26 Jan 2001 19:54:40 +0100 (CET)
Message-Id: <10753.127632@fatcity.com>

Hi Tim and thanks for answering.

Let me question (a little) your answer.

Why do you place SYSTEM in a dedicated disk? is SYSTEM tablespace always supposed to have a hight access rate? if this is true, is it for writing or reading? and why?
I think that SYSTEM has in fact a low access rate (in most cases), because its data is almost always cached in the SGA (data dictionary structure)

I would do the following:

(for a write intensive system)

system, oracle software,temp     DISK1
rollback, control1               DISK2
data,control2                    DISK3
data                             DISK4
indexes                          DISK5
redo                             DISK6



(for a read intensive system)

system, oracle software,temp     DISK1
rollback, control1               DISK2
data,control2                    DISK3
data                             DISK4
index                            DISK5
index,redo                       DISK6

please let me know if I'm wrong,
and comments would be appreciated
thanks

---

Do You Yahoo!?
Envía mensajes instantáneos y recibe alertas de correo con Yahoo! Messenger - http://messenger.yahoo.es Received on Fri Jan 26 2001 - 12:54:40 CST