Problem solve Get help with specific problems with your technologies, process and projects.

Reorganizing data to optimize performance

My company is purchasing additional disks, and we are looking to reorganize our data to optimize performance. The server is running Oracle8i on Solaris and is the back end for a high transaction Web site. We have six SCSI controllers (A-F), 26 18GB disks (0-25), 2 hardware RAID controllers, and Veritas software RAID. The IT group is divided on how to distribute the data. The group with more database experience says that Setup I (reducing write contention) is better, while the group with more hardware experience says that Setup II (avoiding software RAID) is better. Which setup will result in faster performance? Or is there a third way that is even better?

Setup I:

A0: Solaris 
A1: Oracle Software, SYSTEM Tablespace 
A2: REDO logs 
B3: A0 soft mirror 
B4: A1 soft mirror 
B5: A2 soft mirror 
C6: Archived REDO logs, TOOLS tablespace 
C7: ROLLBACK tablespace 
D8: C6 soft mirror 
D9: C7 soft mirror 
E[RAID 0+1]10-17: DATA tablespace 
F[RAID 0+1]18-25: INDEX, TEMP tablespaces 

Setup II:
A0: Solaris 
B3: A0 soft mirror 
E[RAID 0+1]10-17: DATA, SYSTEM, REDO logs, Oracle Software 
F[RAID 0+1]18-25: INDEX, TEMP, Archived REDO logs, TOOLS,ROLLBACK 
(extra disks used in other systems)


This really is an issue for one of the Oracle experts, and I think even they will be hard pressed to give a good answer due to the difficulty in predicting how Oracle will perform on a given Solaris configuration.

The Oracle engine is highly tuned for each implementation platform. What works well on a Z Series mainframe, may or may not work well on an AS-400, and nearly certainly won't work well on an Intel or Solaris platform. Because of the Oracle engine's knowledge of the Solaris platform, it will make many tuning adjustments to its behavior once it determines the hardware configuration. This tuning effect will make it difficult or impossible to accurately predict the engine's behavior under a given load.

As a general rule with Oracle 8i, avoiding write contention will produce the fastest OLTP processing, while maximizing RAID and data redundancy will produce the fastest OLAP processing. I realize that this isn't a concrete answer, but without doing some extensive testing with your particular data and applications, I don't think a concrete answer is possible.

For More Information

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.