Home » RDBMS Server » Performance Tuning » different performance results in Oracle9i vs. MSSQL Server 2000
different performance results in Oracle9i vs. MSSQL Server 2000 [message #136998] Mon, 12 September 2005 12:40 Go to next message
mitra fatolahi
Messages: 38
Registered: October 2002
Member
Hello,

We have performed load test of our java application against both Oracle9i and MSSQL Server 2000 databases. The throughput we got against an Oracle9i environment was less than MSSQL Sever 2000. Both test environment machines were identical with exception of the type of the database.
I have been assigned to look into tuning Oracle9i so we could get at least the same performance as MSSQL Server 2000. My boss believes Oracle should and will perform better if we know how to tune the database. I am new to Oracle and already started reading Oracle9i Database Performance Tuning Guide and Reference. I learned using SQL_TRACE and TKPROF. But so far I have not found any thing in the TKPROF that would explain the performance issue.
What should I be looking for? Do I need to modify any particular parameter in any of the .int files? Any ideas will be appreciated.

Thank you,
Mitra
Re: different performance results in Oracle9i vs. MSSQL Server 2000 [message #137000 is a reply to message #136998] Mon, 12 September 2005 13:00 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
Any reason why you are using the old version of oracle instead of the current one?

Performance tuning is a big topic, probably with regards to any environment. I've found that there are no shortcuts; about the only thing that works is having an understanding of the architecture and concepts of how the environment (database) works.

For that, sounds like you are on the right track in reading the performance tuning guide (10g version is much better than 9i in my opinion). Also the concepts guide is a must read.

A couple common oracle errors that come to mind reading your description is doing row at a time processing. If possible, and it often is, use bulk / set processing. This means, for example, running a single sql statement rather than a program that processing a result set one row at a time. Oracle has lots of capabilities (like analytic functions) that make this possible in many situations.

Also make sure to use the tools that the database provides. This means not trying to write a single application that will run well on multiple databases, because it won't. Keep your data processing as close to the db as possible, meaning use sql and plsql in the db not in the application layer.

An excellent book, especially if you are just starting out, is Tom Kyt's new book which either just came out this week, or will be out next week. Expert oracle programming 9i and 10g. Will be a great book to get you started on the right track.
Re: different performance results in Oracle9i vs. MSSQL Server 2000 [message #137010 is a reply to message #137000] Mon, 12 September 2005 14:12 Go to previous message
Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
SMartin wrote:
>>This means not trying to write a single application that will run well on multiple databases, because it won't.Keep your data processing as close to the db as possible, meaning use sql and plsql in the db not in the application layer.

That is a wise statment.

Oracle and MS-sqlserver are different products.
Both treat the data differently.
Both are depending on different technologies / methods / principles to fetch the data.
So definately you need to customize the application with respect to the database it will be run.

I can quote a number of products that are designed to run against many databases. I am working with one such financial application.
To my horror, all the referential constraints are dealt within the application ( so it is easy to 'plug' against any database technology) and NONE are defined in database. There are hundreds of flaws in this application , which could have been easily dealt with a little database design ( oracle oriented).
Previous Topic: Can I change the DB_BLOCK_SIZE in Oracle 9i?
Next Topic: Oracle9i Function Base index?
Goto Forum:
  


Current Time: Tue Dec 06 20:58:46 CST 2022