Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> OLTP and DSS on one server

OLTP and DSS on one server

From: Robert Friedl <rfriedl_at_softwareengineering.de>
Date: Thu, 14 Dec 2000 09:52:25 +0100
Message-ID: <3a388b9c_2@news2.prserv.net>

I want to run a OLTP and a DSS on one server-hardware (1 GB RAM, 40 GB HDD RAID5, 2 Pentium III Processors).
The DSS (data Warehouse) has 2 fact tables with 400000 records each one and the OLTP-System has to serve up to 100 Users. I'm using Oracle Version 8.1.5.

What's better ?

1.) Create two Oracle 8i Instances and run each system on an own instance (each instance has less SGA memory then it would have using only one instance)

or

2.) Create one Oracle 8i Instance and locate the two applications in an own schema. (one user for dss and one user for oltp)

Thanks
Robert Received on Thu Dec 14 2000 - 02:52:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US