473,735 Members | 2,799 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 2034

"mleal" <ma************ ****@ig.com.br> wrote in message
news:11******** *************@i 39g2000cwa.goog legroups.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******** *************@i 39g2000cwa.goog legroups.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_ALE RT. 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
3510
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 privately on their local machine. Each developer's machine has: * an OS, either Windows 2000 or XP; and * a database, either Oracle 9i or DB2 8.1.
8
14374
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 the database when I log in - Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options
1
2033
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 tool to play with :-((( Regards, JM Blaise
42
6754
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 Management System which wil manage our very large inventory. Anyway comments suggestions welcome Thanks Paul
5
5030
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 working on Access 2000/2002 with pass through queries and linked tables to an Oracle 10g backend (ODBC). Access seems (still) to beat everything else hands down as a front end/ prototyping tool for WIndows based systems. With my type of small...
0
20343
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 3/31/98 Kathy Gleeson ________________________________________
4
3085
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 applications hitting it constantly, all performing many SELECTs, INSERTs and UPDATEs. Are the following the steps I need to take? 1. Stop all the applications hitting the database. 2. Make a backup of the database.
0
2379
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 recommended in a MS note. I can connect to Oracle via tnsping and using SQLPlus but I cannot create a linked db successfully. The linked database errors off with >Cannot initialize data source for OLE provider "OraOLEDB.Oracle" for Lined Server "X"...
1
6233
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 choosing the most efficient way to retrieve this data based upon the evaluation of a number of different criteria. The CBO bases optimization choices on pre-gathered table and index statistics while the RBO makes it's decisions based on a set of ...
0
8964
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
8786
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9327
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9251
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9200
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6049
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4823
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3274
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2190
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.