Re: Getting results from oracle query suck!

From: Vitaliy Mogilevskiy <vit100gain_at_earthlink.net>
Date: Tue, 04 May 1999 12:11:56 -0700
Message-ID: <372F467C.A9A165BB@earthlink.net>

I would start with the basics:

Increase the SGA, DB_BLOCK_BUFFERS, cache the table !

+--------------------------------------------------------------------------+
| Vitaliy Mogilevskiy
| Senior Consultant
| CORE Technology Group, Inc.
| E-mail:    vit100gain_at_earthlink.net
| Fax :      (707) 516-2163
| Web Page:  http://home.earthlink.net/~vit100gain/index.html

|            *** Free DBA Script Library at my Web Page ***
|

| "Never wrestle a pig - you both get dirty and the pig likes it..." | "If the only tool you have is a hammer, everything looks like a nail..."

+--------------------------------------------------------------------------+

MScheuter wrote:

> I have a table that contains customer name information (about 10 fields).
> There are about 1.9 million rows in the table. The table is index by the
> last name. I am writing application code in both C++ using oracle oci and
> java using again the supplied oracle oci drivers (see oracle web site). In
> a test program I am timing the execution of the select statment and then
> timing how long it takes to 'read' (or drain) the rows of data from the
> database. The timing results are as follows:
>
> Rows in Result Set Query Time (ms) Read results time (ms)
> 2824 187 11875
> 211 156 969
> 1330 187 4984
> 1740 78 6062
>
> The test program was run on both a workstation using net8 and locally on the
> server that is running the database using a local connection (no network
> involved) and the results were similiar.
>
> The server is a 2 way 200 mhz intell box with 512 meg ram 80 gig hd space.
> Can someone please explain some areas that I can look at in order to improve
> the performance of reading the result set?
>
> Thanks
> -mike
Received on Tue May 04 1999 - 14:11:56 CDT