Re: 8.1.7.4 + 2 patches hangs on imp, strange waits

"Joel Garry" <joel-garry_at_home.com> wrote in message news:91884734.0307140928.7351091e_at_posting.google.com...
> "Anurag Varma" <avarmadba.skipthis_at_yahoo.com> wrote in message news:<HmWPa.2247$3G5.61_at_nwrdny03.gnilink.net>...
> > "Joel Garry" <joel-garry_at_home.com> wrote in message
> > news:91884734.0307111033.469d6c41_at_posting.google.com...
> > Those waits are common. Most are idle waits. If you open a sql*plus session
> > you will see sql*net message from client. The waits don't seem to be
> > pointing to
> > any obvious problem.
>
> Yeah, my brain was in exp land when I looked at that, had to slap my
> forehead after posting. Always a risk in using fake addresses with
> google posting, no easy cancel. :-)
>
> >
> > Try this:
> > Run a trace on the session doing the import (using oradebug or
> > dbms_system.set_sql_session_in_trace).
> > If using oradebug try event 10046 level 12. See what kind of waits that
> > session is seeing in real time.
>
> Will try. I'm really starting to think those patches didn't fix what
> 8.1.7.4 broke, though.
>
> >
> > and since you have set commit = y ... check on that table: are rows
> > increasing in that table? or is the session
> > just hung? You can also check v$transaction (used_ublk) for more clues.
>
> I've tried several things, the table always gets stuck with 2168324
> rows imported. I tried importing just that table (from the next
> nights export) into an instance running 8.1.7.2, imported 2981011 rows
> just fine. Now I'm trying just that table from the file being used on
> 8.1.7.4 to see if it hangs, I expect it to... it did.
>

---snip---

hmm looks like you are hitting a bug or something is not right after applying those patches. I could guess all I like .. but I suppose you are better off opening a TAR on this.

Let us know if you find out the cause.

Anurag Received on Mon Jul 14 2003 - 21:41:55 CDT