{"id":12336,"date":"2019-07-08T19:36:25","date_gmt":"2019-07-08T19:36:25","guid":{"rendered":"https:\/\/dbtut.com\/?p=12336"},"modified":"2019-07-08T19:36:26","modified_gmt":"2019-07-08T19:36:26","slug":"how-to-check-the-status-of-data-pump-master-and-worker-processes","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/","title":{"rendered":"How To Check the Status of Data Pump Master and Worker Processes"},"content":{"rendered":"

You can access summary information about the status of Data Pump Master and worker processes with the following query.<\/p>\n

  SELECT s.sid,\n         s.module,\n         s.state,\n         s.event    AS event,\n         s.seconds_in_wait           AS secs,\n         sql.sql_text                AS sql_text\n    FROM v$session s JOIN v$sql sql ON sql.sql_id = s.sql_id\n   WHERE s.module LIKE 'Data Pump%'\nORDER BY s.module, s.sid;<\/pre>\n
You can also find out which object the data pump is dealing with and how long this process will take.<\/p>\n
SELECT x.job_name,\n       b.state,\n       b.job_mode,\n       b.degree,\n       x.owner_name,\n       z.sql_text,\n       p.MESSAGE,\n       p.totalwork,\n       p.sofar,\n       ROUND ((p.sofar \/ p.totalwork) * 100, 2)     done,\n       p.time_remaining\n  FROM dba_datapump_jobs  b\n       LEFT JOIN dba_datapump_sessions x ON (x.job_name = b.job_name)\n       LEFT JOIN v$session y ON (y.saddr = x.saddr)\n       LEFT JOIN v$sql z ON (y.sql_id = z.sql_id)\n       LEFT JOIN v$session_longops p ON (p.sql_id = y.sql_id)\n WHERE y.module = 'Data Pump Worker' AND p.time_remaining > 0;<\/pre>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
You can access summary information about the status of Data Pump Master and worker processes with the following query. SELECT s.sid, s.module, s.state, s.event AS event, s.seconds_in_wait AS secs, sql.sql_text AS sql_text FROM v$session s JOIN v$sql sql ON sql.sql_id = s.sql_id WHERE s.module LIKE ‘Data Pump%’ ORDER BY s.module, s.sid; You can also find …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":12337,"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":[4475,4474,4467,4460,4464,4468,4461,4465,4466,4469,4470,4472,4471,4459,4473,4463,4462],"class_list":["post-12336","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-check-expdp-status","tag-check-impdb-status","tag-data-pump-master-processes","tag-data-pump-master-status","tag-data-pump-monitoring","tag-data-pump-worker-processes","tag-data-pump-worker-status","tag-how-to-check-data-pump-import-progress","tag-how-to-check-data-pump-job-progress","tag-how-to-check-import-job-status-in-oracle","tag-how-to-check-the-status-of-the-export-or-import-job-in-oracle","tag-how-to-estimate-export-time-in-oracle","tag-how-to-estimate-import-time-in-oracle","tag-how-to-monitor-data-pump-sessions","tag-impdp-status-example","tag-queries-to-monitor-datapump-jobs","tag-what-happens-during-execution-of-a-data-pump-job"],"aioseo_notices":[],"yoast_head":"\nHow To Check the Status of Data Pump Master and Worker Processes - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Check the Status of Data Pump Master and Worker Processes\" \/>\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\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Check the Status of Data Pump Master and Worker Processes - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Check the Status of Data Pump Master and Worker Processes\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-07-08T19:36:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-07-08T19:36:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-59.png\" \/>\n\t<meta property=\"og:image:width\" content=\"619\" \/>\n\t<meta property=\"og:image:height\" content=\"358\" \/>\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=\"1 minute\" \/>\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\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Check the Status of Data Pump Master and Worker Processes\",\"datePublished\":\"2019-07-08T19:36:25+00:00\",\"dateModified\":\"2019-07-08T19:36:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/\"},\"wordCount\":54,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-59.png\",\"keywords\":[\"check expdp status\",\"check impdb status\",\"Data Pump Master Processes\",\"Data Pump Master Status\",\"Data Pump Monitoring\",\"Data Pump Worker Processes\",\"Data Pump Worker Status\",\"how to check data pump import progress\",\"how to check data pump job progress\",\"how to check import job status in oracle\",\"how to check the status of the export or import job in oracle\",\"how to estimate export time in oracle\",\"how to estimate import time in oracle\",\"How to monitor Data Pump sessions\",\"impdp status example\",\"Queries to Monitor Datapump Jobs\",\"What Happens During Execution of a Data Pump Job\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/\",\"name\":\"How To Check the Status of Data Pump Master and Worker Processes - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-59.png\",\"datePublished\":\"2019-07-08T19:36:25+00:00\",\"dateModified\":\"2019-07-08T19:36:26+00:00\",\"description\":\"How To Check the Status of Data Pump Master and Worker Processes\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-59.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-59.png\",\"width\":619,\"height\":358},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Check the Status of Data Pump Master and Worker Processes\"}]},{\"@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":"How To Check the Status of Data Pump Master and Worker Processes - Database Tutorials","description":"How To Check the Status of Data Pump Master and Worker Processes","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\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/","og_locale":"en_US","og_type":"article","og_title":"How To Check the Status of Data Pump Master and Worker Processes - Database Tutorials","og_description":"How To Check the Status of Data Pump Master and Worker Processes","og_url":"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/","og_site_name":"Database Tutorials","article_published_time":"2019-07-08T19:36:25+00:00","article_modified_time":"2019-07-08T19:36:26+00:00","og_image":[{"width":619,"height":358,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-59.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Check the Status of Data Pump Master and Worker Processes","datePublished":"2019-07-08T19:36:25+00:00","dateModified":"2019-07-08T19:36:26+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/"},"wordCount":54,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-59.png","keywords":["check expdp status","check impdb status","Data Pump Master Processes","Data Pump Master Status","Data Pump Monitoring","Data Pump Worker Processes","Data Pump Worker Status","how to check data pump import progress","how to check data pump job progress","how to check import job status in oracle","how to check the status of the export or import job in oracle","how to estimate export time in oracle","how to estimate import time in oracle","How to monitor Data Pump sessions","impdp status example","Queries to Monitor Datapump Jobs","What Happens During Execution of a Data Pump Job"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/","url":"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/","name":"How To Check the Status of Data Pump Master and Worker Processes - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-59.png","datePublished":"2019-07-08T19:36:25+00:00","dateModified":"2019-07-08T19:36:26+00:00","description":"How To Check the Status of Data Pump Master and Worker Processes","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-59.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-59.png","width":619,"height":358},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/07\/08\/how-to-check-the-status-of-data-pump-master-and-worker-processes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Check the Status of Data Pump Master and Worker Processes"}]},{"@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\/12336","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=12336"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/12336\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/12337"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=12336"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=12336"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=12336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}