Re: Know 1 database, know them all?

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 level -> SQL statements). Ofcourse requests need to be forwarded to the database engine. You need network for that (tcp, pipe, shared memory, etc).

So I think that each database has these 4 areas:

        Network - Synchronization - LIO - PIO

Ofcourse for each database vendor there are different kind of stats / principles in each area. That is where you have to learn.

Optimizing databases is basically reducing PIO, LIO, Synchronization and Network traffic .....

Anjo.

On Saturday 15 February 2003 17:38, you wrote:
> I overheard one guy mention that once you learn one database, you know them
> all. Is this true? Or was he just talking about the theory behind the db?

-- 
----------------------------------------------------------------
Anjo Kolk
http://www.oraperf.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Anjo Kolk
  INET: anjo_at_oraperf.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).