Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h1J076x10761 for ; Tue, 18 Feb 2003 18:07:06 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h1J075Q10756 for ; Tue, 18 Feb 2003 18:07:05 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id MAA02696; Tue, 18 Feb 2003 12:50:35 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00550B98; Tue, 18 Feb 2003 12:18:57 -0800 Message-ID: Date: Tue, 18 Feb 2003 12:18:57 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= Subject: Re: Know 1 database, know them all? Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="------------080201080106060305030302" --------------080201080106060305030302 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit Not quite true, as far as I know.... There's wait stuff in there, although not enough to my taste. There's cpu in there, and the start and stop time, which makes it possible to at least make a crude R = S + W, where the difficult part is breaking down the W into meaningful stuff. A long way to go, but I think they're aware of it. The guys from SQL Server Development I spoke to about it were very interested in the method and liked the whole idea. But don't forget that I'm always wrong. Mogens Broodbakker, Mario wrote: >Mogens, the only problem with your statement about 'oracle myths & king of the new world' is that the only way of looking at SQLServer performance is probably looking at ratio's: there are no wait statistics, there is one(1) latch wait counter though! for the complete system :( (apart from some other almost useless perfmon counters, taht is..) > >regards, >Mario > > >-----Original Message----- >Sent: maandag 17 februari 2003 23:29 >To: Multiple recipients of list ORACLE-L > > >I see it from a slightly different (and probably wrong) angel, at least >regarding the performance of things and databases: If you've worked with >Oracle databases for some time (and have real experience), and know >about the myths and their anti-thesis (use the wait interface instead of >the ¤&#% ratio crap, know about RAID-5, don't have too many indexes, >concentrate on LIO instead of PIO, etc.,etc.) you'll do quite fine. As >Peter Gram once said to me: It's all about getting a database to perform >on a platform. > >You can take your old presentations regarding Oracle myths and change it >into a SQL Server or mySQL presentation, change a few details, and be >king in the new world. > >Mogens > >Robert Eskridge wrote: > > > >>Curiously, the basics are common across styles of cooking. You have >>to learn to coax the flavors out of the fresh ingredients and transform >>them into the proper texture and finish. Once you've mastered Italian >>cooking, you may not be a top notch German cook, but you're probably >>just a recipe or two away from being able to produce a very nice >>German meal... >> >>Databases have a certain similarity. If heading an Oracle project and >>I was given the choice between two people to work on my project, one >>having been the lead architect for a top notch product based on >>Sybase, and the other being an OCP that had worked on lack luster >>products, it would be hard not to pick the former. >> >> >> >>F> Following the same logic..... if I learn to cook a good Italian dish, then I >>F> must automatically be an expert in preparing top-class Chinese, German, >>F> Malay, Hungarian and French cuisine .... Yeah, right ! >> >>F> Ferenc Mantfeld >> >> >> >> >> > > > > --------------080201080106060305030302 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Not quite true, as far as I know.... There's wait stuff in there, although not enough to my taste. There's cpu in there, and the start and stop time, which makes it possible to at least make a crude R = S + W, where the difficult part is breaking down the W into meaningful stuff. A long way to go, but I think they're aware of it. The guys from SQL Server Development I spoke to about it were very interested in the method and liked the whole idea.

But don't forget that I'm always wrong.

Mogens

Broodbakker, Mario wrote:
Mogens, the only problem with your statement about 'oracle myths & king of the new world' is that the only way of looking at SQLServer performance is probably looking at ratio's: there are no wait statistics, there is one(1) latch wait counter though! for the complete system :( (apart from some other almost useless perfmon counters, taht is..)

regards,
Mario
 

-----Original Message-----
Sent: maandag 17 februari 2003 23:29
To: Multiple recipients of list ORACLE-L


I see it from a slightly different (and probably wrong) angel, at least 
regarding the performance of things and databases: If you've worked with 
Oracle databases for some time (and have real experience), and know 
about the myths and their anti-thesis (use the wait interface instead of 
the ¤&#% ratio crap, know about RAID-5, don't have too many indexes, 
concentrate on LIO instead of PIO, etc.,etc.) you'll do quite fine. As 
Peter Gram once said to me: It's all about getting a database to perform 
on a platform.

You can take your old presentations regarding Oracle myths and change it 
into a SQL Server or mySQL presentation, change a few details, and be 
king in the new world.

Mogens

Robert Eskridge wrote:

  
Curiously, the basics are common across styles of cooking.  You have
to learn to coax the flavors out of the fresh ingredients and transform
them into the proper texture and finish.  Once you've mastered Italian
cooking, you may not be a top notch German cook, but you're probably
just a recipe or two away from being able to produce a very nice
German meal...

Databases have a certain similarity.  If heading an Oracle project and
I was given the choice between two people to work on my project, one
having been the lead architect for a top notch product based on
Sybase, and the other being an OCP that had worked on lack luster
products, it would be hard not to pick the former.



F> Following the same logic..... if I learn to cook a good Italian dish, then I
F> must automatically be an expert in preparing top-class Chinese, German,
F> Malay, Hungarian and French cuisine .... Yeah, right !

F> Ferenc Mantfeld

--------------080201080106060305030302-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: mln@miracleas.dk Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).