There seems to be something that you miss in this discussion: Writing applications!
It's very likely very true, that you can use your DBA skills from one database
and apply them on another, but many application developers have truely failed
to understand that the different databases are very
februari 200321:19
To: Multiple recipients of list ORACLE-L
Subject:Re: Know 1 database, know them all?
Not quite true, as faras 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
Title: RE: Know 1 database, know them all?
I see it from a slightly different (and probably wrong) angel
Angel? Hmmm... is that a veiled reference to the satanic dark side Luke?
-Original Message-
From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 17, 2003 3
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
Perhaps a philosophical discussion is in order on the roles of Right Angels
versus Obtuse Angels versus Acute Angels. I would hypothesize that Right
Angels occupy the uppermost regions of Heaven. Obtuse Angels, being obtuse
and mentally slow, are responsible for the enforcement of Murphy's Law.
Yeah, that could be :).
OK, OK: Angle, angle, angle, angle. Undskyld.
Best regards,
The Oracle Angels of Denmark (TOAD)
Orr, Steve wrote:
RE: Know 1 database, know them all?
I see it from a slightly different (and probably
wrong) angel
Angel? Hmmm
Actually there are wait stats in SQL server that you can only see with
Precise Indepth for SQLServer ;-)
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
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
recipients of list ORACLE-LSubject: Re:
Know 1 database, know them all?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
should write a SQLserver paper on
that!
Mario
-Original Message-From: Mogens Nørgaard
[mailto:[EMAIL PROTECTED]]Sent: dinsdag 18 februari 2003
21:19To: Multiple recipients of list ORACLE-LSubject:
Re: Know 1 database, know them all?Not quite true, as far
as I know
Either the person knows sybase and SQL Server or the drugs kicked in. Much of the
theory is similar but there are enough differences that only RTFMing and experience
can help. I do SQL Server, Oracle and now am learning DB2. They all claim to be
ANSI92 compliant. The problem is that they
LOL!!
Thanks for replies guys.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, February 17, 2003 2:28 AM
Either the person knows sybase and SQL Server or the drugs kicked in.
Much of the theory is similar but there are enough differences
Maybe both, LOL.
Oracle, DB2, Sybase etc are all archetecturly different.
You HAVE to learn each one of them. With Informix, even their OLTP
and DW products are two different animals.
-Original Message-
Sent: Monday, February 17, 2003 5:29 AM
To: Multiple recipients of list ORACLE-L
Following the same logic. if I learn to cook a good Italian dish, then I
must automatically be an expert in preparing top-class Chinese, German,
Malay, Hungarian and French cuisine Yeah, right !
Ferenc Mantfeld
Dreaming costs you nothing. Not dreaming costs you everything.
- Original
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 ¤#%
Learning the first database is the hardest for me. After which
learning the rest was easy.
--
Lyndon Tiu
Quoting Mogens Nørgaard [EMAIL PROTECTED]:
I see it from a slightly different (and probably wrong) angel, at
least
regarding the performance of things and databases: If you've worked
hello
general guideline
the SQL language is (almost) the same standardized one everywhere. BUT not everything
is always implemented yet everywhere.
e.g.:
storing binary objects, stored procedures, java vm, sql*plus,storing java procedures
(obfuscated or not) ...
e.g.:
conceptual differences
It depends on the level you are looking at it. From a high level, every
database does PIO (read/write data to disk), then from the buffer cache
(global/local) it does do LIO (accessing buffers). Access to these buffers is
synchronized (latching/locking not only on buffers but also on a higher
Must have been basic theory or perhaps they were referring to ANSI SQL which
we all use.
You will find substantial differences between UDB, DB2/MVS, Oracle and SQL
Server and all the others. I have worked at one time or another with the
above mentioned and moving from one to another was fairly
19 matches
Mail list logo
