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

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