When performing impdp, I get this error ORA-12518: (TNS:listener could not hand off client connection). I have set auto memory management, why does it not allocate more memory to large_pool. What can I do to address this issue.

Thank you.

Manny,

"I have set auto memory management"

Not a good idea, it's buggy. I would go back to manual:

http://www.dba-oracle.com/t_amm_automatic_memory_resize.htm

"why does it not allocate more memory to large_pool. "

Are you setting the "buffers" import parm?

It could be many things, but I'll bet if you turn-off AMM it will work. Here are other common causes of the ORA-12518 error:

http://www.dba-oracle.com/sf_ora_12518_tns..._connection.htm

Am using impdp (datapump) is there a buffer parameter for datapump?

"is there a buffer parameter for datapump?"

Sorry, yes.

You can control input buffers with impdp using the "buffer" parm. Also, there are other parms that control allocated memory:

http://www.dba-oracle.com/oracle_tips_load_speed.htm

It makes a big difference in load time:

Import Option
Elapsed Time (Seconds)
Time Reduction

commit=y
120
-

commit=y
buffer=64000
100
17%

commit=n
buffer=30720
72
40%

commit=N
buffer = 64000
67
44%