Re: Import hangs

Walt wrote:

> I've just installed Oracle 9.2 on a W2k machine. I'm playing around
> with importing data from a full export of a 8.1.6 / Win NT instance.
>
> Import hangs in various situations - is this normal? It doesn't do it
> all the time, but it does it aften enough to cause concern. When it
> hangs, you can't create any new connections, although sometimes
> currently connected users can still access data. The only way to get it
> back is to restart the database.
>
> I wish I could provide more specific details, but the onset seems to be
> random at this point.
>
> I understand that import will throw errors (I can catch them in the
> logfile and puzzle out what the problem is), but this behavior is
> frustrating in that there's no error code or anything to go on.
>
> Have other users experineced this?

What does the tail end of alert_SID.log contain?

I suspect the DB is in archive redo logfile mode and either the archiver is not turned on or the disk fills up.

Enable SQL_TRACE on the instance & see where all the time is being spent. Received on Fri Oct 31 2003 - 18:37:57 CST