Message-Id: <10595.115050@fatcity.com> From: "Andrey Bronfin" Date: Sun, 20 Aug 2000 12:44:44 +0200 Subject: Fw: capacity issues 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@lists.sunysb.edu ; ORACLE-L@fatcity.com ; = oracledba@quickdoc.co.uk ; dbi-users@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 : 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 :=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

Hi , friends !

Thanks a lot for your replies = !

U all suggested 2 different DBs on = different=20 machines , and U are absolutely right .

But there are some new developments = here : there is=20 no budget for 2 servers . So the first option (a) is gone away=20 .

I must use one Sun E 220 machine with 2 = CPUs=20 .

So the question that remains is : one = or 2 DBs=20 .

I'd say 2 different DBs ( like U = all suggested=20 ) , but i'm unsure because :

- I plan the DB = block size =3D 8K=20 for both the DBs .

I can't = select a=20 smaller db_block_size for the OLTP since the machine's IO unit is 8K ,=20

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 .

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 = ?

- 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

- 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 .

Would U please comment ?

Thanks U very-very much in advance = !

----- Original Message -----=20

From: Andrey=20 Bronfin

To: ORACLE-L@lists.sunysb.edu ; ORACLE-L@fatcity.com ; oracledba@quickdoc.co.uk ; dbi-users@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=20 OLTP & DataWarehouse .

I need to plan the machines for = production=20 .

I have 3 options :

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 ) .

b) Create the same 2 DBs = and put them=20 on one Sun E 220 machine with 2 CPUs .

c) Create 1 database = to host all=20 the tables of both the OLTP & reports parts of the application=20 .

Would U please give some guideness on = the above ,=20 some pros & cons for each approach .

Basically there are 2 decisions to take = :=20

is it better to have one mixed = database or 2=20 different DBs

and

in case U have 2 DBs , is better = to put them=20 on one machine or on 2 different machines .

Thank U VERY much in advance = .

Every tip is VERY appreciated = .

Andrey=20