Re: Performance Tuning

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 Tue Feb 29 2000 - 00:00:00 CST