-1

My application that wraps around Oracle Data pump's executables IMPDP and EXPDP takes random amounts of time for the same work. On further investigation, I see it waiting for again random amounts of time with the event 'wait for unread message on broadcast channel'. This makes the application take anytime b/w 10 minutes to over an hour for the same work.

I fail to understand if this has something to do with the way my application uses these executables, or it has got something to do with Load on my server or something totally alien to me.

Shravan
  • 223
  • 1
  • 5
  • 12
  • Network activity ? Maybe if you said whether you get these on the imp or exp side (or any other details about what is going on) you may get some more answers. – Gary Myers May 13 '10 at 08:51
  • This is the case for both export side and import side and both sometimes. I will look into network activity in a little greater detail to see if there is something wrong there. – Shravan May 13 '10 at 09:34

2 Answers2

1

There's a bunch of processes and sessions involved in a data pump operation. I suspect you are looking at the master processes, not at the worker processes. So all that event is saying is that the Master process spends more time waiting for the worker process when the job takes longer. Which is fairly useless information.

You need to monitor the worker processes and see why they are taking longer.

Gary Myers
  • 34,963
  • 3
  • 49
  • 74
0

Those wait events are usually considered to be "idle" waits - i.e. Oracle has nothing to do, it is waiting for further data/instructions.

Jeffrey Kemp
  • 59,135
  • 14
  • 106
  • 158
  • My question exactly, these are idle waits and I still see expdp if invoked directly from my console, showing me these waits (So, it can't be waiting on something?). So was curious if there is something I am missing here. I am more curious about expdp's behavior and not faulting what Oracle is trying to do as such. – Shravan May 13 '10 at 09:37