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: Understanding direct path write event

Re: Understanding direct path write event

From: SL <sebastien_louchart_at_yahoo.fr>
Date: 7 Dec 2005 12:24:50 -0800
Message-ID: <1133987090.088929.297990@f14g2000cwb.googlegroups.com>


>Direct path write means that you are
>writing from user buffer (typically in PGA) directly to the database files,
>bypassing the db buffer cache. That is the way BLOB fields are
>read/written, and it was done for speed.

Ok pour Direct path insert. I had the intuition of something like that. With your explanation, things are clearer anyway. BTW, do you where I can find further data on that topic ?

> I don't know what are you doing

Personnally nothing, just trying to optimize perf ;) webMethods executes mass insertions of LOBs into the DB. These operations produce contention (and also internal errors but this is another story).
LOB contain wm's internal data. AFAIK, no way to use a BFILE instead of those LOB.

-- 
SL
Received on Wed Dec 07 2005 - 14:24:50 CST

Original text of this message

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