Using gzip to run export/import with oracle

[Brian Gebhard_1]

Hello All,

I'm just got a new server in and on the old one I was using red hat 7.2 and oracle 8.1.7. this new one I'm using Rhas 2.1 and 9.2.0.1. On the old one when I used gzip through a pipe file which I created with mknod command the pipe file held 8k at a time. Now on the new machine it's only holding 4k at a time. This is drastically increase the time to import my database. is there anyway to change the size?

[Dirk Wiedemann]

Hello,

I don't know Rhas 2.1, but as an assumption:
If you create a fifo, is it possible, that the buffersize depends on blocksize of your used filesystem?

Dirk

[Alexander M. Ermes]

Hi there.
I attached a script, that we use for export.
It is written for HP-UX 11.00, so you may have to adjust it a bit.
Rgds
Alexander M. Ermes

[Brian Gebhard_1]

Rhas 2.1 is how oracle seems to be calling Red Hat Advanced Server 2.1. The block size of the filesystem is set to 8k that's one reason why I'm not sure why the pipe file is only 4k. As far as the script that was attached. It appears that you are using gzip and gunzip also. What size is your pipe file? Do you know if there is a way to increase the size? I have a script that does basically the same thing but I'd like to know if there is a way to increase the pipe file.