Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> How to attach Job in expdp-impdp
Ruchi_G
post Jul 28 2015, 03:58 AM
Post #1


Newbie
*

Group: Members
Posts: 4
Joined: 8-June 15
Member No.: 50,617



Hi,

I m importing a schema using the following command:

impdp schemas=abc directory=test dumpfile=exp.dmp logfile=imp.log

Username: sys as sysdba
Password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_FULL_02" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_02": sys/********@db2 AS SYSDBA
Processing object type SCHEMA_EXPORT/ROLE_GRANT



And the impdp job has started processing.


Now, how do i attach this job to check its status..

Pls help...
Go to the top of the page
 
+Quote Post
burleson
post Jul 28 2015, 07:08 AM
Post #2


Advanced Member
***

Group: Members
Posts: 13,577
Joined: 26-January 04
Member No.: 13



Hi Ruchi,

>> to check its status..

Just tail -f imp.log




--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
Jhil
post Jul 28 2015, 05:47 PM
Post #3


Advanced Member
***

Group: Members
Posts: 37
Joined: 27-May 15
Member No.: 50,586



Hi burleson,

I have a question from Data Pump.


Some folks are suggesting . When we do import job , same number of parallel value must be used.


At that time of export job , i set parallel=4

At that time of import job , should i set parallel=4 ?

>> If i ignore , does it slow down my import process ?

Thanks.





Go to the top of the page
 
+Quote Post
burleson
post Jul 28 2015, 06:01 PM
Post #4


Advanced Member
***

Group: Members
Posts: 13,577
Joined: 26-January 04
Member No.: 13



Hi Johil,

>> When we do import job , same number of parallel value must be used.

"same number as what? CPU_count?

***************************************************

>> At that time of import job , should i set parallel=4 ?

As a rule of thumb, use cpu_count-1: Please read

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




--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
burleson
post Jul 28 2015, 06:03 PM
Post #5


Advanced Member
***

Group: Members
Posts: 13,577
Joined: 26-January 04
Member No.: 13



Hi Ruchi,

>> If i ignore , does it slow down my import process ?

Parallel can be faster, it depends on several FACTORS:

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


--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
Ruchi_G
post Jul 28 2015, 11:32 PM
Post #6


Newbie
*

Group: Members
Posts: 4
Joined: 8-June 15
Member No.: 50,617



QUOTE (burleson @ Jul 28 2015, 08:08 AM) *
Hi Ruchi,

>> to check its status..

Just tail -f imp.log



Hi,

But what if i want to check how many bytes has it processed?? How do i attach this job??
Go to the top of the page
 
+Quote Post
burleson
post Jul 29 2015, 07:22 AM
Post #7


Advanced Member
***

Group: Members
Posts: 13,577
Joined: 26-January 04
Member No.: 13



Hi Ruchi,

>> But what if i want to check how many bytes has it processed??

Please read: http://www.dba-oracle.com/t_monitor_data_pump_import_job.htm

You can try v$session_longops

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

http://dba-oracle.com/googlesearchsite_pro...%3D23940&ss=

***********************************************

>> How do i attach this job??

I have no idea what this means, sorry . . . .


--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
James Smith
post May 8 2017, 05:10 AM
Post #8


Newbie
*

Group: Members
Posts: 1
Joined: 8-May 17
Member No.: 51,966



Nice to read about How to attach Job in expdp-impdp. its really a wonderful and helpful post for me. Thanks.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 22nd October 2017 - 09:41 PM