| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: capacity issues
The problem for mixing OLTP-batch is not in CPU, but in I/O bottleneck, so
use 2 DB on 2 machine would be better.
Rivaldi
>From: "Andrey Bronfin" <bronfin_at_VisualTop.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: capacity issues
>Date: Thu, 17 Aug 2000 13:49:24 -0800
>
>Dear list !
>
>I have a very urgent question :
>I have a mixed-type application here , it's both OLTP & DataWarehouse .
>I need to plan the machines for production .
>I have 3 options :
> a) Create 2 databases - one for OLTP and one for the batch processing -
>reports and put them on 2 different machines ( Sun E 220 with 1 CPU each )
>.
> b) Create the same 2 DBs and put them on one Sun E 220 machine with 2
>CPUs .
> c) Create 1 database to host all the tables of both the OLTP & reports
>parts of the application .
>
>Would U please give some guideness on the above , some pros & cons for each
>approach .
>Basically there are 2 decisions to take :
> is it better to have one mixed database or 2 different DBs
>and
> in case U have 2 DBs , is better to put them on one machine or on 2
>different machines .
>
>Thank U VERY much in advance .
>Every tip is VERY appreciated .
>
>
>
>
>
>Andrey Bronfin
>VisualTop.com
>+972-3-5275757.
>
>
>
 |
 |