Re: DB_FILE_MULTIBLOCK_READ_COUNT

First off, It's great to see people like Kevin and Thomas in this newsgroup. They, along with others have helped me a great deal when I was starting out, and even today... Anyway, In regards to the Buffer parameter on an Import, Use a large number (like 10MB) to speed up the process-Oracle will acquire as much as you specify and will not return an error if it can't find the amount.

This Information was stolen out of "Tuning Oracle" by Oracle Press, ISBN 0-07-881181-3

Good Luck,
Satar

In article <363E864C.4386520C_at_uswest.net>,   rfish1 <rfish1_at_uswest.net> wrote:
> Kevin--
> I tried the procedure below for the first time this weekend, and for the
record
> it worked great. However, portions of it are still running; I had two tables
> with LONG columns, and these imports failed because my buffer size was too
> small. As was recommended in the docs, I increased the buffer size by powers
of
> 2 until it was big enough to work, which is fine but slow. I may be asking too
> much, even of Oracle, but is there a way to globally estimate the buffer size
> using a query, e.g. tell me the length of the longest LONG in tables that have
> them?
> --Russ
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Nov 03 1998 - 13:08:19 CST