Xref: alice comp.databases.oracle.tools:14206 Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!newsfeed.nyu.edu!wesley.videotron.net!Pollux.Teleglobe.net!uunet!in3.uu.net!amgwy1.bp.com!consultancy-support@uunet.pipex.com From: "James L. Gehring" Newsgroups: comp.databases.oracle.tools Subject: Oracle, NT, and 150 Users? Date: 7 Jul 1998 16:42:27 GMT Organization: Another Netscape News Server User Lines: 24 Message-ID: <01bda9c6$1842ed60$cccf0180@amclvw26464.clv.am.bp.com> X-Newsreader: Microsoft Internet News 4.70.1161 I am sizing a box to run 150 users. These users will be processing transactions that will require them to query (and only query) the data at 2 to ten minute intervals throughout the day. The data that they are querying gets batch loaded into the system at night (Yep, downloaded from a mainframe!) so there is almost no insert/update processing on this "Data Mart" server from the user perspective. Total data size is under 1 Gig (indexes and all). If I buy a dual processor Pentium with 1/2 a Gig of RAM and some good SCSI controllers, should this be sufficient if 100 of these users were to fire off a query at approximatley the same time? I would really be interested in hearing from someone who has a system like this or has experienced its performance first-hand. We are planning on using Windows NT Server 4.0 and Oracle 8.0.3. Please send your response via e-mail to: GehrinJL@bp.com Thanks in advance! James L. Gehring Compuware, Inc.