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: At a loss after a tune-up, please help!

Re: At a loss after a tune-up, please help!

From: Zdenka Spoljaric <928330N_at_KNOTES.KODAK.COM>
Date: 1998/02/17
Message-ID: <34E9F103.D65AF2C7@KNOTES.KODAK.COM>#1/1

db_file_multiblock_read_count is the maximum number of blocks read in one I/O operation during a sequential scan. When the valu of this parameter is high, the optimizer my choose a full table scan.

Regards

NNOOR wrote:

> My work station: Oracle 7.3, WinNT4, P233+96MB RAM.
> I have server and client (my development tool) running on the
> same machine. BTW, I am using Delphi 3.01 C/S to access Oracle.
>
> I created a LONG RAW type field in a table. The typical size of
> data in that field is 2MB. I was reading all of the data from
> that field into a buffer in my application and then saving it
> to a file. I had noticed that to get all that 2MB of field data
> into my application *on the same local machine* would take about
> 1.5 minutes and A LOT OF DISK THRASHING. Following is what I tried
> to fix it.
>
> My INITORCL.ORA is the stock file installed as part of the Oracle.
> I opened it and simply uncommented all of the parameters for the
> LARGE installation. I then ran my application again and this time
> the time to get the 2MB of field data into my application was only
> like 2 or 3 seconds. Talk about improvement!
>
> I am wondering that what parameter in the stock initorcl.ora is
> that important? Is it the "db_file_multiblock_read_count"?
>
> Thanks very much for your help!
>
> Regards,
> Nasir (nnoor_at_cris.com)
Received on Tue Feb 17 1998 - 00:00:00 CST

Original text of this message

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