Re: Oracle Server Recommendation

From: Peter Sylvester <peters_at_mitre.org>
Date: Thu, 07 Nov 2002 13:24:38 -0500
Message-ID: <aqeb56$oon$1@newslocal.mitre.org>

Try turning on sql_trace for your session and run tkprof on the resulting trace file. It should show a breakdown of each SQL statement issued and resources consumed for each.

--Peter

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-
>
>
Received on Thu Nov 07 2002 - 12:24:38 CST