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

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 Mon Feb 16 1998 - 00:00:00 CST