Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: High Volume Inserts
>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