{"id":12332,"date":"2019-07-10T18:34:34","date_gmt":"2019-07-10T18:34:34","guid":{"rendered":"https:\/\/dbtut.com\/?p=12332"},"modified":"2019-07-10T18:34:35","modified_gmt":"2019-07-10T18:34:35","slug":"data-pump-import-export-is-running-slow-or-hangs","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/","title":{"rendered":"Data Pump Import\/Export is Running Slow or Hangs"},"content":{"rendered":"

When Data pump is running slowly or when it is hanging, determining which query is currently running will help in understanding the problem. The following script will show the SQL statement executed with the current wait event every 10 minutes.<\/p>\n

First, create a script named dp_current_sql.sql that contains the following code.<\/p>\n

dp_current_sql.sql<\/strong><\/p>\n

spool current_sql.out\n\noradebug setospid &spid\n\nselect to_char (sysdate, 'YYYY-MM-DD HH24:MI:SS') from dual;\n\noradebug current_sql\nbreak by 1;\n\nselect w.event, w.wait_time,w.seconds_in_wait, w.p1,w.p2,w.p3\nfrom v$session s, v$process p, v$session_wait w\nwhere s.paddr=p.addr and s.module='Data Pump Worker' and s.sid=w.sid;\n\nexec DBMS_LOCK.SLEEP(600);\n\nselect to_char (sysdate, 'YYYY-MM-DD HH24:MI:SS') from dual;\n\noradebug current_sql\nbreak by 1;\n\nselect w.event, w.wait_time,w.seconds_in_wait, w.p1,w.p2,w.p3\nfrom v$session s, v$process p, v$session_wait w\nwhere s.paddr=p.addr and s.module='Data Pump Worker' and s.sid=w.sid;\n\nexec DBMS_LOCK.SLEEP(600);\n\nselect to_char (sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;\n\noradebug current_sql\nbreak by 1;\n\nselect w.event, w.wait_time,w.seconds_in_wait, w.p1,w.p2,w.p3\nfrom v$session s, v$process p, v$session_wait w\nwhere s.paddr=p.addr and s.module='Data Pump Worker' and s.sid=w.sid;\n\nspool off;<\/pre>\n
Connect with sqlplus as SYSDBA. Determine the SPID of the Data Pump Worker (DW00) process with the following query.<\/p>\n
set lines 150 pages 100 numwidth 7\ncol program for a38\ncol username for a10\ncol spid for a7\nselect to_char (sysdate,'YYYY-MM-DD HH24:MI:SS') \"DATE\", s.program, s.sid, \ns.status, s.username, d.job_name, p.spid, s.serial#, p.pid \nfrom v$session s, v$process p, dba_datapump_sessions d \nwhere p.addr=s.paddr and s.saddr=d.saddr;<\/pre>\n
Run the dp_current_sql.sql script you created above from sqlplus. When asked for the spid value, enter the SPID value detected in the above step.<\/p>\n
SQL> @dp_current_sql.sql\nEnter value for spid:<\/pre>\n
When you run the script, it will produce output similar to the following. You can also find the output in the current_sql.out file in the current directory.<\/p>\n
SQL> @dp_current_sql.sql\nEnter value for spid: 70112\nOracle pid: 129, Unix process pid: 70112, image: oracle@oradb.oracle.local (DW00)\n\nTO_CHAR(SYSDATE,'YY\n-------------------\n2018-10-13 17:29:42\n\n\ninsert \/*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') *\/ \ninto sys.dbms_stats_id_map_tab (c5, c1, c2, cn)\nselect \/*+ leading(s) index(s) *\/ \ndistinct s.c5, s.c1, s.c2, i.partition_name cn\nfrom \"SYS\".\"IMPDP_STATS\" s, dba_ind_partitions i\nwhere s.c5 = :1 and s.c1 = :2\nand s.type in ('I','i') and s.n13 is not null \nand s.c2 like 'SYS_%' and s.c3 is null\nand s.c5 = i.index_owner and s.c1 = i.index_name \nand s.n13 = i.partition_position\nand s.c2 != i.partition_name and s.statid is null\n\nEVENT WAIT_TIME\n---------------------------------------------------------------- ----------\nSECONDS_IN_WAIT P1 P2 P3\n--------------- ---------- ---------- ----------\ndb file sequential read -1\n2 1 151735 1\n\nwait for unread message on broadcast channel 0\n2 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n3 9981956688 1.0534E+10 0\n\n\nEVENT WAIT_TIME\n---------------------------------------------------------------- ----------\nSECONDS_IN_WAIT P1 P2 P3\n--------------- ---------- ---------- ----------\nwait for unread message on broadcast channel 0\n5 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n3 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n5 9981956688 1.0534E+10 0\n\n\nEVENT WAIT_TIME\n---------------------------------------------------------------- ----------\nSECONDS_IN_WAIT P1 P2 P3\n--------------- ---------- ---------- ----------\nwait for unread message on broadcast channel 0\n1 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n2 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n5 9981956688 1.0534E+10 0\n\n\nEVENT WAIT_TIME\n---------------------------------------------------------------- ----------\nSECONDS_IN_WAIT P1 P2 P3\n--------------- ---------- ---------- ----------\nwait for unread message on broadcast channel 0\n4 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n2 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n4 9981956688 1.0534E+10 0\n\n\nEVENT WAIT_TIME\n---------------------------------------------------------------- ----------\nSECONDS_IN_WAIT P1 P2 P3\n--------------- ---------- ---------- ----------\nwait for unread message on broadcast channel 0\n4 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n1 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n1 9981956688 1.0534E+10 0\n\n\nEVENT WAIT_TIME\n---------------------------------------------------------------- ----------\nSECONDS_IN_WAIT P1 P2 P3\n--------------- ---------- ---------- ----------\nwait for unread message on broadcast channel 0\n2 9981956688 1.0534E+10 0\n\n\n16 rows selected.\n\n\nPL\/SQL procedure successfully completed.\n\n\nTO_CHAR(SYSDATE,'YY\n-------------------\n2018-10-13 17:39:43\n\nmerge \/*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') *\/ into optstat_user_prefs$ d using (select o.obj#, s.c2 pname, s.n1 valnum, s.cl1 valchar, s.d1 chgtime, s.n2 spare1 from \"SYS\".\"IMPDP_STATS\" s, obj$ o, user$ u where s.c5= :ownname and s.c1= :tabname and s.type = 'P' and SYS_OP_MAP_NONNULL(s.statid) = SYS_OP_MAP_NONNULL(:stid) and o.owner#=u.user# and u.name= :ownname and o.type# = 2 and o.name= :tabname ) s on (d.obj#=s.obj# and d.pname=s.pname) when matched then update set valchar=s.valchar when NOT matched then insert (obj#, pname, valnum, valchar, chgtime, spare1) values(s.obj#, s.pname, s.valnum, s.valchar, s.chgtime, s.spare1)\n\nEVENT WAIT_TIME\n---------------------------------------------------------------- ----------\nSECONDS_IN_WAIT P1 P2 P3\n--------------- ---------- ---------- ----------\ndb file sequential read -1\n5 1 163263 1\n\nwait for unread message on broadcast channel 0\n1 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n2 9981956688 1.0534E+10 0\n\n\nEVENT WAIT_TIME\n---------------------------------------------------------------- ----------\nSECONDS_IN_WAIT P1 P2 P3\n--------------- ---------- ---------- ----------\nwait for unread message on broadcast channel 0\n4 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n2 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n4 9981956688 1.0534E+10 0\n\n\nEVENT WAIT_TIME\n---------------------------------------------------------------- ----------\nSECONDS_IN_WAIT P1 P2 P3\n--------------- ---------- ---------- ----------\nwait for unread message on broadcast channel 0\n5 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n1 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n4 9981956688 1.0534E+10 0\n\n\nEVENT WAIT_TIME\n---------------------------------------------------------------- ----------\nSECONDS_IN_WAIT P1 P2 P3\n--------------- ---------- ---------- ----------\nwait for unread message on broadcast channel 0\n3 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n1 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n3 9981956688 1.0534E+10 0\n\n\nEVENT WAIT_TIME\n---------------------------------------------------------------- ----------\nSECONDS_IN_WAIT P1 P2 P3\n--------------- ---------- ---------- ----------\nwait for unread message on broadcast channel 0\n3 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n5 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n5 9981956688 1.0534E+10 0\n\n\nEVENT WAIT_TIME\n---------------------------------------------------------------- ----------\nSECONDS_IN_WAIT P1 P2 P3\n--------------- ---------- ---------- ----------\nwait for unread message on broadcast channel 0\n1 9981956688 1.0534E+10 0\n\n\n16 rows selected.\n\n\nPL\/SQL procedure successfully completed.\n\n\nTO_CHAR(SYSDATE,'YY\n-------------------\n2018-10-13 17:49:43\n\n\ninsert \/*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') *\/\ninto sys.dbms_stats_id_map_tab (c5, c1, c2, cn)\nselect \/*+ leading(s) index(s) *\/ \ndistinct s.c5, s.c1, s.c2, d.partition_name cn\nfrom \"SYS\".\"IMPDP_STATS\" s, \n(select u.name table_owner, op.name table_name, \nop.subname partition_name, \ntp.part# partition_position\nfrom user$ u, obj$ op, \n(select obj#, part# from tabpartv$\nwhere bo# = :1\nunion all\nselect obj#, part# from tabcompartv$\nwhere bo# = :2\n) tp\nwhere u.user# = op.owner# and op.type# = 19 and op.obj# = tp.obj#\n) d\nwhere s.c5 = :3 and s.c1 = :4\nand s.type in ('T','C','E',\n\nEVENT WAIT_TIME\n---------------------------------------------------------------- ----------\nSECONDS_IN_WAIT P1 P2 P3\n--------------- ---------- ---------- ----------\ndb file sequential read -1\n497 1 137287 1\n\nwait for unread message on broadcast channel 0\n1 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n2 9981956688 1.0534E+10 0\n\n\nEVENT WAIT_TIME\n---------------------------------------------------------------- ----------\nSECONDS_IN_WAIT P1 P2 P3\n--------------- ---------- ---------- ----------\nwait for unread message on broadcast channel 0\n4 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n2 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n4 9981956688 1.0534E+10 0\n\n\nEVENT WAIT_TIME\n---------------------------------------------------------------- ----------\nSECONDS_IN_WAIT P1 P2 P3\n--------------- ---------- ---------- ----------\nwait for unread message on broadcast channel 0\n5 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n1 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n4 9981956688 1.0534E+10 0\n\n\nEVENT WAIT_TIME\n---------------------------------------------------------------- ----------\nSECONDS_IN_WAIT P1 P2 P3\n--------------- ---------- ---------- ----------\nwait for unread message on broadcast channel 0\n3 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n1 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n3 9981956688 1.0534E+10 0\n\n\nEVENT WAIT_TIME\n---------------------------------------------------------------- ----------\nSECONDS_IN_WAIT P1 P2 P3\n--------------- ---------- ---------- ----------\nwait for unread message on broadcast channel 0\n3 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n5 9981956688 1.0534E+10 0\n\nwait for unread message on broadcast channel 0\n5 9981956688 1.0534E+10 0\n\n\nEVENT WAIT_TIME\n---------------------------------------------------------------- ----------\nSECONDS_IN_WAIT P1 P2 P3\n--------------- ---------- ---------- ----------\nwait for unread message on broadcast channel 0\n1 9981956688 1.0534E+10 0\n\n\n16 rows selected.\n\nSQL><\/pre>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
When Data pump is running slowly or when it is hanging, determining which query is currently running will help in understanding the problem. The following script will show the SQL statement executed with the current wait event every 10 minutes. First, create a script named dp_current_sql.sql that contains the following code. dp_current_sql.sql spool current_sql.out oradebug …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":12333,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[4446,4444,4449,4447,4443,4448,4445,4456,4454,3686,4452,4458,4450,4451,3684,4476,4477,4453],"class_list":["post-12332","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-data-pump-export-hangs","tag-data-pump-export-is-running-slow","tag-data-pump-export-job-is-hanging","tag-data-pump-import-hangs","tag-data-pump-import-is-running-slow","tag-data-pump-import-job-is-hanging","tag-data-pump-is-hanging","tag-data-pump-slow","tag-expdp-slow","tag-expdp-slow-in-12c","tag-expdp-taking-long-time","tag-how-to-improve-expdp-performance","tag-how-to-improve-impdp-performance","tag-how-to-improve-impdp-performance-12c","tag-how-to-speed-up-import-process-in-oracle","tag-impdp-slow","tag-impdp-taking-long-time","tag-oracle-12c-impdp-very-slow"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":3066,"today_views":0},"yoast_head":"\nData Pump Import\/Export is Running Slow or Hangs - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Data Pump Import\/Export is Running Slow or Hangs\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Pump Import\/Export is Running Slow or Hangs - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Data Pump Import\/Export is Running Slow or Hangs\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-07-10T18:34:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-07-10T18:34:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-58.png\" \/>\n\t<meta property=\"og:image:width\" content=\"635\" \/>\n\t<meta property=\"og:image:height\" content=\"378\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"Data Pump Import\/Export is Running Slow or Hangs\",\"datePublished\":\"2019-07-10T18:34:34+00:00\",\"dateModified\":\"2019-07-10T18:34:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/\"},\"wordCount\":144,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-58.png\",\"keywords\":[\"data pump export hangs\",\"Data Pump Export is Running Slow\",\"data pump export job is hanging\",\"data pump import hangs\",\"Data Pump Import is Running Slow\",\"data pump import job is hanging\",\"Data Pump is hanging\",\"data pump slow\",\"expdp slow\",\"expdp slow in 12c\",\"expdp taking long time\",\"how to improve expdp performance\",\"how to improve impdp performance\",\"how to improve impdp performance 12c\",\"how to speed up import process in oracle\",\"impdp slow\",\"impdp taking long time\",\"oracle 12c impdp very slow\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/\",\"name\":\"Data Pump Import\/Export is Running Slow or Hangs - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-58.png\",\"datePublished\":\"2019-07-10T18:34:34+00:00\",\"dateModified\":\"2019-07-10T18:34:35+00:00\",\"description\":\"Data Pump Import\/Export is Running Slow or Hangs\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-58.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-58.png\",\"width\":635,\"height\":378},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Pump Import\/Export is Running Slow or Hangs\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Pump Import\/Export is Running Slow or Hangs - Database Tutorials","description":"Data Pump Import\/Export is Running Slow or Hangs","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/","og_locale":"en_US","og_type":"article","og_title":"Data Pump Import\/Export is Running Slow or Hangs - Database Tutorials","og_description":"Data Pump Import\/Export is Running Slow or Hangs","og_url":"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/","og_site_name":"Database Tutorials","article_published_time":"2019-07-10T18:34:34+00:00","article_modified_time":"2019-07-10T18:34:35+00:00","og_image":[{"width":635,"height":378,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-58.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"Data Pump Import\/Export is Running Slow or Hangs","datePublished":"2019-07-10T18:34:34+00:00","dateModified":"2019-07-10T18:34:35+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/"},"wordCount":144,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-58.png","keywords":["data pump export hangs","Data Pump Export is Running Slow","data pump export job is hanging","data pump import hangs","Data Pump Import is Running Slow","data pump import job is hanging","Data Pump is hanging","data pump slow","expdp slow","expdp slow in 12c","expdp taking long time","how to improve expdp performance","how to improve impdp performance","how to improve impdp performance 12c","how to speed up import process in oracle","impdp slow","impdp taking long time","oracle 12c impdp very slow"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/","url":"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/","name":"Data Pump Import\/Export is Running Slow or Hangs - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-58.png","datePublished":"2019-07-10T18:34:34+00:00","dateModified":"2019-07-10T18:34:35+00:00","description":"Data Pump Import\/Export is Running Slow or Hangs","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-58.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-58.png","width":635,"height":378},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/07\/10\/data-pump-import-export-is-running-slow-or-hangs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Data Pump Import\/Export is Running Slow or Hangs"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/12332","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=12332"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/12332\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/12333"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=12332"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=12332"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=12332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}