setup for online project.

From: KULJEET <kuljeet_twtpl_at_hotmail.com>
Date: 5 Aug 2003 21:39:26 -0700
Message-ID: <febbed51.0308052039.253e803e_at_posting.google.com>


hi
i am working on develop online project.
on oracle 8i database(on win2000),
oracle 9i app server(on win 2000),
and developer 2000

Now the main issue is performance.
over 400 employees connected with oracle with browser. now the problem is how to set the performance of oracle 8i server and 9i application server.

  1. what are the harware configration of oracle 8i database and 9i app server like (Ram,OS,processor,harddisk etc.)

we are running 8i on win 2000 ,
**Is any performance benefit if we install 8i database on linux.

2.ten tables with more than 30,00,000 rows(each table) for these table how to set tablespace extends size ,and table extends size
now our planning is to create diff tablespace for each table is it ok or not.

3.how to set init.ora file with sga and diffrent buffer paramere & its size.

thanks in advance. Received on Wed Aug 06 2003 - 06:39:26 CEST

Original text of this message