Re: Multiple databases - best performance scenario



On Apr 11, 8:28 am, Paul <paul.f...@xxxxxxxxxxxxxxxxx> wrote:
Hi

My company has the need to manage data for multiple customers. High
volume concurrent read and write access will be required to these
databases, so I'm trying to determine what hardware scenario is best
to support this requirement. Each database will be approx 0.5Tb in
size, and there are around 10 customers, meaning an overall size of
approx 5Tb.

The scenarios I'm considering are:

1) One large physical server with local RAID storage, or poss external
SAN
2) Multiple small physical servers (prob blades) connected to SAN
3) Multiple small virtual servers connected to SAN

The OS will be Linux (prob RHEL). When I'm using the word database
above I'm meaning a set of data tables for a particular customer - I
understand that this may have a different technical interpretation for
Oracle.

Any suggestions or pointers to further information would be
appreciated. Please post further questions if I've missed important
information.

Many thanks

Paul

I think hpuxrac pretty much covered it, I would just add:

You might consider checking licensing costs at the oracle store
(though keep in mind you should be able to negotiate with your Oracle
salesperson). The costs are not linear, small configuration changes
can mean big bucks, and overshadow hardware costs. Standard Edition
may be good enough for you, though Enterprise Edition may be required
if you need to meet Service Level Agreements (because of the
limitations of things like the Performance monitoring pack of EM).
The doc set at http://tahiti.oracle.com covers some of this.

Check whether Oracle supports your idea of virtualization.

jg
--
@home.com is bogus.
http://www.ratemycop.com/
.



Relevant Pages

  • Multiple databases - best performance scenario
    ... My company has the need to manage data for multiple customers. ... Multiple small physical servers connected to SAN ... When I'm using the word database ...
    (comp.databases.oracle.server)
  • Re: Basic Oracle Concepts
    ... A sqlserver database is more or less the ... Multiple Oracle Homes are created during installation. ...
    (comp.databases.oracle.misc)
  • Re: Access and Linked tables to Oracle
    ... The initial Access database was created in Access 2000. ... database on multiple machines with similar results in all cases. ... We are using the Oracle ODBC drivers for the database connectivity. ... is really slow if the primary key gets created on that table ...
    (microsoft.public.access.tablesdbdesign)
  • Re: same application on multiple schemas
    ... application must have its own "database", or schema, Oracle speaking. ... Suppose you were providing and appplication for multiple customers on a single database. ...
    (comp.databases.oracle.server)
  • Re: relink oracle linked tables in code
    ... to the way Access can have a control named "cboxGetStuff" on multiple forms. ... must be distinguished by owner name and database name in certain contexts. ... But my oracle db contains only 1 table with that name. ...
    (microsoft.public.access.modulesdaovba)