473,242 Members | 1,816 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,242 software developers and data experts.

Tuning on Oracle 10g and SQL Server 2005

Does anyone have some more detailed information about how Oracle and MS
implement / allow Tuning on Oracle 10g and SQL Server 2005 and the
differences between them?

Which of them, In a deep comparison about it, allow better tuning and
why.
Regards,
Marcio Evangelista

May 3 '06 #1
3 2007

"mleal" <ma****************@ig.com.br> wrote in message
news:11*********************@i39g2000cwa.googlegro ups.com...
Does anyone have some more detailed information about how Oracle and MS
implement / allow Tuning on Oracle 10g and SQL Server 2005 and the
differences between them?

I really can't help there.

Which of them, In a deep comparison about it, allow better tuning and
why.
"Both and neither". This is a religious question. Both sides will argue
that their system is better, can tune better, etc. If you go by TPC
benchmarks, I think right now SQL Server is "beating" Oracle. But that
could also just mean Oracle hasn't come up with a new test bed yet. (and if
they are "winning" now, it'll only be a matter of time before Microsoft
responds :-)
In any event, generally both can be highly tuned and optimized by people who
know the systems well enough.



Regards,
Marcio Evangelista

May 4 '06 #2
My only comment would be that the tuning tools such as Database Engine
Tuning Advisor and SQL Profiler come as part of the product set (and price)
whereas with Oracle you need to spend a lot of money on the tuning advisor
tools seperately.

In terms of server tuning a lot is done for you by SQL Server, you don't
need to tweak many things, in fact I rarely ever need to use sp_configure to
change anything except fixing memory size.

Tony.

--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
"mleal" <ma****************@ig.com.br> wrote in message
news:11*********************@i39g2000cwa.googlegro ups.com...
Does anyone have some more detailed information about how Oracle and MS
implement / allow Tuning on Oracle 10g and SQL Server 2005 and the
differences between them?

Which of them, In a deep comparison about it, allow better tuning and
why.
Regards,
Marcio Evangelista

May 4 '06 #3
mleal wrote:
Does anyone have some more detailed information about how Oracle and MS
implement / allow Tuning on Oracle 10g and SQL Server 2005 and the
differences between them?

Which of them, In a deep comparison about it, allow better tuning and
why.
Regards,
Marcio Evangelista


The tuning on the two systems is vastly different from multiple
standpoints. Speak with respect to Oracle most tuning done these
days is done using built-in tools that take advantage of Oracle's
wait interface, AWR (Automated Workload Repository) and ASH (Active
Session History).

Included in the Oracle kernel is an instrumented capability to see
and evaluate what is happening at both the database, operating
system, and hardware levels. Statistics are collected at predetermined
intervals (often enough to be useful, not so often as to burden the
system) and can be viewed through SQL queries (used by the dinosaurs)
through OEM, DBConsole, and the Grid Control.

When I look to tune queries in Oracle I use EXPLAIN PLAN AUTOTRACE,
and 10046 and 10053 traces. In 9i I use StatsPack. In 10g I use AWR,
ASH, and the Grid.

If you want to get an idea of the granularity of information
instrumented in Oracle go to www.psoug.org. Click on Morgan's Library,
then click on DBMS_SERVER_ALERT. The tables at the top of the page
show most of the metrics collected.

HTH

Daniel Morgan
www.psoug.org
May 4 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: renny | last post by:
Dear Oracle/DB2 DBAs, I'm looking for advice on tuning Oracle 9i and DB2 8.1 for rollbacks. I have a number of developers, who each build and test our client/server database application...
8
by: danbredy | last post by:
Hi, I'm attempting to connect to an Oracle database using SQL Server 2005 Express (OS is Windows XP Professional) and having absolutely no luck. Here is the information SQL Plus gives me about...
1
by: Jean-Marc Blaise | last post by:
Hi, I find much regrettable that Database Engine Tuning Advisor be not part of MS-Express Edition ... A server without such help is not a server. Besides, you've got the tutorials, but not the...
42
by: Paul | last post by:
Anyone know where I can find some good resources to help us choose between SQL and Oracle ( Progress Openedge as well ) . Any comments on what you would choose ?? We are creating a new Warehouse...
5
by: dreadnought8 | last post by:
I've worked with mdbs, and with SQL Server to a lesser extent, with Access as a front end, on commercial-strength systems for quite a while, starting with A97. The last 8 months or so, I've been...
0
by: Medhatithi | last post by:
Hi, I have been in several ways benefiited from this site. I would like to share some sql tuning techniques(simple, but effective) with you all. SQL Tuning Tips Oracle Tips Session #6 ...
4
by: Tommy Hayes | last post by:
Hello all, I want to use the SQL Server 2005 Tuning Advisor on our database, and I'm hoping someone here can just confirm the steps for me. We have a 10GB database that has a number of...
0
by: Mark D Powell | last post by:
I have a 64 bit SQL Server 2005 SP2 on a Windows 2003 x64. The developer said that he needed to use OLE to talk to Oracle so I went to Oracle and downloaded the 64 bit OraOLDDB driver as...
1
by: Vinod Sadanandan | last post by:
A Roadmap To Query Tuning ============================ For each SQL statement, there are different approaches that could be used to retrieve the required data. Optimization is the process of...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.