Re: Oracle Server Recommendation

From: Chuckster <chuckycarson_at_networkcloud.com>
Date: Wed, 06 Nov 2002 16:33:31 -0800
Message-ID: <3DC9B4DB.1050807@networkcloud.com>

You really need to analyze the system and gather performance metrics. The main three areas a bottleneck can develop are memory, cpu, and I/O.

If these all seem ok, I would look at the SQL and any procedures and determine if the bottleneck is internal Oracle contention.

At first guess, I would say your bottleneck is in the disk partitioning.

Hope this help,
CC

Scallica wrote:
> Hello,
>
> I am very new to Oracle. I recently setup an Oracle 8 server on a NT 4
> server. I have have a database with 25 tables, the largest table having
> 450,000 records. The system is 500 mhz with 256mb of RAM. Is this sufficient
> or does the machine need more horsepower? I have a VB app that uses the
> database and it runs really slow. Any ideas?
> Thanks.
>
> -Scallica-
>
>

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Wed Nov 06 2002 - 18:33:31 CST