Re: high through put system

On 22 Aug 2006 22:42:44 -0700, vissuyk_at_yahoo.com wrote:

>Hi All,
>
>We have a Servlet application that has to process 10K requests per
>second. In every request, we need to perform one lookup and one insert
>operation. The data size per select/insert is about 1K (makes up one
>row).
>
>We are using Oracle 10.2. We are no where near the needed through put.
>How can we scale this application?. Any suggestions are appreciated.
>Any proven patterns will be very much appreciated. We are going to have
>RAC too (soon), but this wont add to the tyhroughtput, I see it is a
>increasing the availability.
>
>ANy thoughts or ideas are appreciated.
>
>Thanks
>
>Vissu

You aren't using bind varianles, are you? Not using bind variables is the #1 method to make Oracle unscalable. Also, this doesn't look much like an interactive app, so why aren't you using the right tool for the right job (like Sql*loader and similar)?
If you have to use an interactive process, you should be performing BULK COLLECT and BULK INSERT, not 1 row at a time, and definitely NOT 1 commit PER RECORD.

Your post has 'badly engineered app' inscribed all over it.

--
Sybrand Bakker, Senior Oracle DBA