- Depends on why it's waiting (ie is it your process that is making it
wait )
- Not all waits are unavoidable. try NOLOGGING, moving to a faster
filesystem , making the log files bigger , tuning checkpointing and so on
7 hours is a bit long for only 2G...
"Harry Boswell" <hboswel1_at_bellsouth.net> wrote in message
news:3cfeeae2.222412482_at_news1.lig.bellsouth.net...
> On Thu, 06 Jun 2002 06:44:22 +0200, Sybrand Bakker
> <postbus_at_sybrandb.demon.nl> wrote:
>
> >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
>
> We're in the process of moving to 8.1.7. Will that version provide a
boost
> in speed?
>
>
> >2 tune the log writer. The waits are unavoidable.
> >
>
> Maybe it's just because I've been here 16 hours today, but... if the
waits
> are unavoidable, what will tuning do? Or am I misinterpreting what you've
> said?
>
> Thanks,
> Harry Boswell
>
Received on Thu Jun 06 2002 - 04:05:30 CDT
