Re: Performance Tuning

Also try www.lonyx.com, it's hosted by Kevin Loney who wrote books for Oracle Press.

Regards,

Patrice Boivin
Oracle DBA

Martin Hepworth wrote:

> Al
> Oracle performance tuning is an aquired skill (just like anything
> really). You need to monitor your database and tune accordingly.
>
> There's some excellent advice in the Oracle tuning manual. Also the
> totally excellant "Oracle Performance Tuning" by Gurry & Corrigan
> published by O'reilly ISBN , which you get from your fav bookstore
> (online or otherwise). This gives you methodology to run through in
> order to tune your Oracle instance.
>
> Martin
>
> Al Hails wrote:
> >
> > Hi
> >
> > I'm currently building a 3-tier application to work with SQL Server 7 and
> > Oracle 8.0.5 using VB COM objects running under MTS for the middle tier and
> > a ASP-driven web front-end.
> >
> > The application works fine, apart from the performance under Oracle, which
> > we had managed to get working OK on another server, but perhaps more through
> > luck than judgement, but after porting it to a new server, I have made all
> > the obvious changes to the initialization file, redo logs, and rollback
> > segments that I gleened from the Oracle documentation, but although
> > performance has improved slightly (ie MSDTC no longer get stuck in a loop on
> > our application server), it is pretty terrible compared to SQL Server.
> >
> > I'm a complete beginner when it comes to Oracle, so I may be making some
> > fairly basic mistakes.
> >
> > I have attached a copy of my current init file, I have increased the 2 redo
> > logs to 10 MB each, and 3 of the rollback segments to 5 Mb each (though I
> > guess they should grow anyway if they needed to).
> >
> > Has anyone got any suggestions, or perhaps testing strategies that i could
> > try to narrow the problem down?
> >
> > Thanks in advance
> >
> > Al
> >
> > Name: orcl_config.ora
> > orcl_config.ora Type: application/x-unknown-content-type-ORA_auto_file
> > Encoding: x-uuencode
Received on Fri Apr 07 2000 - 00:00:00 CDT