topic Using gzip to run export/import with oracle in Operating System - Linux

Using gzip to run export/import with oracle

Brian Gebhard_1 — Thu, 29 Aug 2002 15:26:52 GMT

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?

Re: Using gzip to run export/import with oracle

Dirk Wiedemann — Fri, 30 Aug 2002 10:17:40 GMT

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

Re: Using gzip to run export/import with oracle

Alexander M. Ermes — Mon, 02 Sep 2002 12:58:34 GMT

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

Re: Using gzip to run export/import with oracle

Brian Gebhard_1 — Tue, 03 Sep 2002 13:55:14 GMT

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.