This is a multi-part message in MIME format.
------=_NextPart_000_019E_01C00AA4.6A4BF110
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi , friends !
Thanks a lot for your replies !
U all suggested 2 different DBs on different machines , and U are =
absolutely right .
But there are some new developments here : there is no budget for 2 =
servers . So the first option (a) is gone away .
I must use one Sun E 220 machine with 2 CPUs .
So the question that remains is : one or 2 DBs .
I'd say 2 different DBs ( like U all suggested ) , but i'm unsure =
because :
- I plan the DB block size =3D 8K for both the DBs .=20
I can't select a smaller db_block_size for the OLTP since the =
machine's IO unit is 8K ,=20
and i'm afraid to put db_block_size=3D16K for the batch processing =
DB , since i've never tried it and i don't know the impacts of =
db_block_size=3D16K on memory , for example .
But may be i'm missing something here . Are there other =
significant init.ora parameters that are opposite in OLTP vs batch =
processing systems ?
=20
- The other argument towards creating one DB is that the reports =
will be running only certain amount of time at off-pick hours and most =
of the time only the OLTP application will be running , so it can =
benefit from using all the available CPU & memory .=20
=20
- Regarding I/O : i'll create different tablespaces on different =
disks for the OLTP & DataWarehouse tables & indexes in order to solve =
I/O contradictions between the 2 types of applications .
Would U please comment ?
Thanks U very-very much in advance !
- Original Message -----=20
From: Andrey Bronfin=20
To: ORACLE-L_at_lists.sunysb.edu ; ORACLE-L_at_fatcity.com ; =
oracledba_at_quickdoc.co.uk ; dbi-users_at_isc.org=20
Sent: Thursday, August 17, 2000 11:40 PM
Subject: capacity issues
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 :
- 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 ) .
- Create the same 2 DBs and put them on one Sun E 220 machine with 2 =
CPUs .
- 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 :=20
is it better to have one mixed database or 2 different DBs=20
and=20
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.
=20
------=_NextPart_000_019E_01C00AA4.6A4BF110
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#d4d0c8>
<DIV><FONT face=3DArial size=3D2>Hi , friends !</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Thanks a lot for your replies =
!</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>U all suggested 2 different DBs on =
different=20
machines , and U are absolutely right .</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>But there are some new developments =
here : there is=20
no budget for 2 servers . So the first option (a) is gone away=20
.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I must use one Sun E 220 machine with 2 =
CPUs=20
.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>So the question that remains is : one =
or 2 DBs=20
.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I'd say 2 different DBs ( like U =
all suggested=20
) , but i'm unsure because :</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2> - I plan the DB =
block size =3D 8K=20
for both the DBs . </FONT></DIV>
<DIV><FONT face=3DArial size=3D2> I can't =
select a=20
smaller db_block_size for the OLTP since the machine's IO unit is 8K ,=20
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> and i'm afraid =
to put=20
db_block_size=3D16K for the batch processing DB , since i've never tried =
it and i=20
don't know the impacts of db_block_size=3D16K on memory , for example=20
.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> But may =
be i'm=20
missing something here . Are there other significant init.ora parameters =
that are opposite in OLTP vs batch processing systems =
?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> </FONT></DIV>
<DIV><FONT face=3DArial size=3D2> - The other argument =
towards=20
creating one DB is that the reports will be running only certain amount =
of time=20
at off-pick hours and most of the time only the OLTP application =
will be=20
running , so it can benefit from using all the available CPU & =
memory .=20
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> =
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> - Regarding =
I/O : i'll=20
create different tablespaces on different disks for the OLTP & =
DataWarehouse=20
tables & indexes in order to solve I/O contradictions between the 2 =
types of=20
applications .</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Would U please comment ?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Thanks U very-very much in advance =
!</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV style=3D"FONT: 10pt arial">----- Original Message -----=20
<DIV style=3D"BACKGROUND: #e4e4e4; font-color: black"><B>From:</B> <A=20
href=3D"mailto:bronfin_at_VisualTop.com" =
title=3Dbronfin_at_VisualTop.com>Andrey=20
Bronfin</A> </DIV>
<DIV><B>To:</B> <A href=3D"mailto:ORACLE-L_at_lists.sunysb.edu"=20
title=3DORACLE-L_at_lists.sunysb.edu>ORACLE-L_at_lists.sunysb.edu</A> ; <A=20
href=3D"mailto:ORACLE-L_at_fatcity.com"=20
title=3DORACLE-L_at_fatcity.com>ORACLE-L_at_fatcity.com</A> ; <A=20
href=3D"mailto:oracledba_at_quickdoc.co.uk"=20
title=3Doracledba_at_quickdoc.co.uk>oracledba_at_quickdoc.co.uk</A> ; <A=20
href=3D"mailto:dbi-users_at_isc.org" =
title=3Ddbi-users_at_isc.org>dbi-users_at_isc.org</A>=20
</DIV>
<DIV><B>Sent:</B> Thursday, August 17, 2000 11:40 PM</DIV>
<DIV><B>Subject:</B> capacity issues</DIV></DIV>
<DIV><BR></DIV>
<DIV><FONT face=3DArial size=3D2>Dear list !</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I have a very urgent question =
:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I have a mixed-type application here , =
it's both=20
OLTP & DataWarehouse .</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I need to plan the machines for =
production=20
.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I have 3 options :</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> a) Create 2 databases - =
one for OLTP=20
and one for the batch processing - reports and put them on 2 =
different=20
machines ( Sun E 220 with 1 CPU each ) .</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> b) Create the same 2 DBs =
and put them=20
on one Sun E 220 machine with 2 CPUs .</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> c) Create 1 database =
to host all=20
the tables of both the OLTP & reports parts of the application=20
.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Would U please give some guideness on =
the above ,=20
some pros & cons for each approach .</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Basically there are 2 decisions to take =
:=20
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> is it better to have one mixed =
database or 2=20
different DBs </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>and </FONT></DIV>
<DIV><FONT face=3DArial size=3D2> in case U have 2 DBs , is better =
to put them=20
on one machine or on 2 different machines .</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Thank U VERY much in advance =
.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Every tip is VERY appreciated =
.</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2><BR>Andrey=20
Received on Sun Aug 20 2000 - 05:44:44 CDT
