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: High Volume Inserts

Re: High Volume Inserts

From: Joel Garry <joel-garry_at_home.com>
Date: 26 Sep 2005 15:12:36 -0700
Message-ID: <1127772756.342180.192240@g44g2000cwa.googlegroups.com>


>would this experiment present the hypothesis
that the database is the bottleneck here?

Not really. But anyways, use a tool like the performance monitor in OEM to see what exactly the database is waiting on and the SQL that is being used. Also, use tools on the db server like netstat, vmstat, sar etc., to see if there are other bottlenecks there. Then blame the network.

As a developer, go read any current book by Thomas Kyte. Also, see asktom.oracle.com, search for bulk insert. Then blame websphere :-)

Where is the validation coming from?

jg

-- 
@home.com is bogus.
http://www.pcdi.com/courses/wf/
Received on Mon Sep 26 2005 - 17:12:36 CDT

Original text of this message

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