Oracle server partitioning strategy

From: 10Squared (news_at_firewallinabox.com)
Date: 04/28/03 

Date: Mon, 28 Apr 2003 15:06:22 -0400

Hello All,

I would like to set up a Sun V880 with 6 * 72 GB drives to maximize database
performance. The database will be Oracle 9i. The system has 8 GB of memory
and 4 * 900 MHz CPUs. It is a development server and will also host
multiple Weblogic 8.1 server instances. My first inclination is to install
the OS, swap, Oracle and Weblogic binaries on the first two drives (RAID
0+1), then distribute the database files (data files, indexes, temp files,
etc.) across the remaining 4 disks. Is there a better setup for this
configuration where the database will be making large numbers of very
complicated joins? Also, in order to make sure I get specific parts of the
database on separate spindles, but allow for failover, is it possible and
advisable to mirror at the partition level with Solaris 9, e.g. each drive
with a data partition and a mirror partition (of a different drive of
course). Thank you for your time.

Cheers,

Jim

Relevant Pages

  • Re: What so special about PostgreSQL and other RDBMS?
    ... That's exactly the link the licence agreement for the database points to when it ... comes to what wecan expect for paying support. ... > "Oracle may provide additional releases or versions of its programs ... If the requirements are volatile I'd do a long term contract detailing what ...
    (comp.lang.php)
  • A cool DBA job wanted
    ... 7, Oracle 6, Sybase, SQL Server ... Proposed proactive database monitoring through ... strategies to administer remote Oracle databases ... Trained installation and support personnel in basic ...
    (comp.databases.oracle.server)
  • Re: I want to add to myknowledge
    ... 7, Oracle 6, Sybase, SQL Server ... Oracle Database Administrator ... Trained installation and support personnel in basic ... Senior Oracle Database Administrator ...
    (comp.databases.oracle.server)
  • Re: choices regarding where to place code - in the database or middle tier
    ... Before Oracle decided to allow you to write stored procedures in Java, ... Even without Java existing, let alone being hosted in the database, you ... of languages that they developed for the middle tier, ... the .NET developers out there will be faced with this choice. ...
    (comp.lang.java.programmer)
  • Re: choices regarding where to place code - in the database or middle tier
    ... Before Oracle decided to allow you to write stored procedures in Java, ... Even without Java existing, let alone being hosted in the database, you ... of languages that they developed for the middle tier, ... the .NET developers out there will be faced with this choice. ...
    (comp.lang.java.databases)
Loading