Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Article about supposed "murky" future for Oracle

Re: Article about supposed "murky" future for Oracle

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Thu, 1 Apr 2004 18:55:00 GMT
Message-ID: <406C6584.EDFF0EA5@remove_spam.peasland.com>


> It is onmode -B (upper case B)
> onmode -B is a unix command line command to trigger dirty page writes to
> disk. It is not a blocked call and unlike LRU writes, it writes in chunks,
> making it order of magnitude faster than LRU writes, which is also
> a non blocked write, but not a chunk write.

This onmode command must be Informix-specific, i.e. not part of a typical Unix distro.

Isn't this like double checkpointing, or did I miss something? Why not just checkpoint more often than every 10 minutes?

> ps: A DBA friend of mine told me that this approach is Oracleish approach
> where it is very common to do such things by scripts :-)

Not in any of my databases. I don't force any writes to disk that the RDBMS doesn't do for me automatically. I don't know very many DBAs who do....

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"
Received on Thu Apr 01 2004 - 12:55:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US