Re: IMPDP blocking itself?

  • From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 10 Aug 2010 08:35:57 -0500 (CDT)

Hey Stephan,

> Looking at AWRs from any time during the time this has been stuck, the DP
> workers all appear to be stuck on compiling various packages (I don't see
> anything in v$sql or v$sqlarea with the sql_id's being reported in the AWRs
> - but the module in AWR shows DP Worker)
>
> Any thoughts?
>
> We're on 10.2.0.4 on Win2k3 x64.

Bug 7439689 - impdp worker process may spin (Doc ID 7439689.8)

This bug looks to be specifically for Windows, although you'd have to trace
it to know if it's looping in the same modules.

GL!

Rich

--
//www.freelists.org/webpage/oracle-l


Other related posts: