Viswamitra's blog

Today one of my client asked me to provide estimates size of the export backup using expdp utility. I have executed the below command.

[oracle@node1 bin]$ expdp directory=DATA_PUMP_DIR full=y estimate_only=yes

Export: Release 11.2.0.1.0 – Production on Wed Feb 3 00:06:56 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
Starting “SYS”.”SYS_EXPORT_FULL_01″:  /******** AS SYSDBA directory=DATA_PUMP_DIR full=y estimate_only=yes
……………………….

Then it got hanged , no errors in alert log also. I have checked the same in dba_datapump_sessions and v$session , I found the below info.

SQL> select SID,WAIT_CLASS,EVENT from v$session where SADDR in (select SADDR from dba_datapump_sessions);

       SID    WAIT_CLASS           EVENT
———- ——————–  —————————————-
        48     enqueue                    Streams AQ: enqueue blocked on low memory

I have checked the same in metalink and found “EXPDP And IMPDP Slow Performance In 11gR2 and 12cR1 And Waits On Streams AQ: Enqueue Blocked On Low Memory (Doc ID 1596645.1)”.

After increasing the size of streams pool “streams_pool_size”. It worked fine.

ALTER SYSTEM SET streams_pool_size=256M SCOPE=both;