Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Server Recommendation
Peter Sylvester <peters_at_mitre.org> wrote in message news:<aqeb56$oon$1_at_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-
> >
> >
tkprof and trace files for a newbie? Well, ok I guess. Perhaps he should try the performance thingie of OEM.
jg
-- @home is bogus. Ask a smart question, get a smart answer.Received on Thu Nov 07 2002 - 17:49:57 CST