Re: Import Waits

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 06 Jun 2002 06:44:22 +0200
Message-ID: <d3qtfu4tl1880u7pbn9ak5e399644psmov@4ax.com>

On Thu, 06 Jun 2002 04:18:12 GMT, hboswel1_at_bellsouth.net (Harry Boswell) wrote:

>I was running an import, with an export file about 2GB in size; about 80%
>of the data is in one table with a LONG RAW column. The import is taking
>about 7 hours; the target db is not in archive log mode. The machine is a
>Sun E4500, Oracle 8.0.5. I was watching TOAD's Database Monitor, and
>noticed that there seemed to be lots of waits for log writes and control
>file IOs. Is there some way to lessen these waits? This export file was
>created with indexes=n, rows=y, constraints=n; I have a second file with
>indexes=y, rows=n, constraints=y. Any ideas?
>
>Thanks,
>Harry Boswell

Ideas
1 stop running a desupported version
2 tune the log writer. The waits are unavoidable.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jun 05 2002 - 23:44:22 CDT