Ask the Expert

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:

    Requires Free Membership to View

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)

Thanks!


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


This was first published in April 2001

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: