Xref: alice comp.databases.oracle.server:33538 Path: alice!news-feed.fnsi.net!cyclone.i1.net!typhoon.stlnet.com!news-stl.cp.verio.net!news-nyc.telia.net!newsfeed.cwix.com!206.63.63.70!nwnews.wa.com!brokaw.wa.com!not-for-mail From: Dan Newsgroups: comp.databases.oracle.server Subject: Re: Databas creation Date: Wed, 11 Nov 1998 10:35:49 -0800 Organization: EXE Lines: 15 Message-ID: <3649D905.5A34965A@exesolutions.com> References: <71tkgv$ulf$1@nnrp1.dejanews.com> Reply-To: dmorgan@exesolutions.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Mailer: Mozilla 4.06 [en] (WinNT; I) To: bindu999@my-dejanews.com > We have an Oracle 8 (medium sized ) database.According to Oracle > doucmentation , this set up supports upto 100 concurrent users. > I would like to know , if we can scale the existing database to handle > more concurrent users ? or do we have to recreate another (large) > database. Sizing involves many things. If you are just adding more users you can probably just make the necessary changes in your INITSID.ORA and bounce the database. If the new users will also be generating more records and more transactions you may need to change block size which requires a compelete rebuild, resizing your extents, etc. Much more information is required to answer your question. Daniel A. Morgan