RE: Know 1 database, know them all?

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
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
  INET: mln_at_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_at_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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Broodbakker, Mario
  INET: Mario.Broodbakker_at_hp.com

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_at_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).