Methods to terminate Imp/exp and EXPDP/IMPDP processes

Methods to terminate Imp/exp and EXPDP/IMPDP processes
Lone Wind A sword Released: 2013-08-22 17:37 Column: Database development click: 2,613 times Grab Sofa
First, stop Exp/imp optimization speed
Can kill the process directly, but first to kill the parent process, and then kill the child process, only kill the child process, Exp/imp will also be executed in the background
Example: Ps-ef |grep imp query to pid,kill-9 PID, kill-9 ppid, you can

Second, stop EXPDP/IMPDP
This cannot be handled simply by the kill process, because this is a job
1, EXPDP/IMPDP Parameters:
ATTACH Connect to an existing job, such as ATTACH [= Job name].
Job_name can be queried by dba_datapump_jobs:
Sql>select * from Dba_datapump_jobs
Owner_name job_name operation
------------------------------ ------------------------------ --------------------------------------------------- ---------
Job_mode State degree Attached_sessions D Atapump_sessions
------------------------------------------------------------ ------------------------------ ---------- ----------- ------ -----------------
SYSTEM sys_export_full_01 EXPORT
Full executing 1 1 3
Example 1:
C:\Documents and SETTINGS\ADMINISTRATOR>EXPDP System/sys attach=sys_export_full_01
Export:release 11.2.0.1.0-production on Saturday July 13 23:53:55 2013
Copyright (c) 1982, the Oracle and/or its affiliates. All rights reserved.
Connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-production
With the partitioning, OLAP, Data Mining and Real application testing options
Job: sys_export_full_01
Owner: SYSTEM
Action: EXPORT
Creator Permissions: TRUE
Guid:7374dcc3e7d547b3b755865e4db59f10
Start time: Saturday, 13 July, 2013 23:53:57
Mode: Full
Example: Tony
max degree of parallelism: 1
EXPORT Job Parameters:
Parameter value of argument name:
Client_command system/******** directory=dir_dump dumpfile=dir_dump:bigtable.dmp logfile=dir_dump:bigtable.log full =y
Status: Idling
Bytes processed: 0
Current degree of parallelism: 1
Job Error Count: 0
Dump file: d:\impdp\bigtable.dmp
Bytes written: 5,177,344
Worker 1 Status:
Process Name: DW00
Status: UNDEFINED
Export> Stop_job
Are you sure you want to stop this job ([y]/n): Y
Are you sure you want to stop this job ([y]/n): Y
Are you sure you want to stop this job ([y]/n): Y
Are you sure you want to stop this job ([y]/n): Y
Are you sure you want to stop this job ([y]/n): Y---------------Just can't stop, in Dba_datapump_jobs still can find the record, but the job has stopped.
-----has been resolved, you need to enter Yes
Export> Kill_job
Are you sure you want to stop this job ([y]/n): YES
Ctl+c can enter interactive mode at execution time, both Windows and Linux are the same.
When you re-enter EXPDP/IMPDP, you can perform the following interactive commands:
$EXPDP Username/password,
Common commands for interactive mode:
Continue_client returns to record mode. If it is idle, the job will be restarted.
Start_job initiates the recovery of the current job.
Status at the default value (0) Displays the job status of the frequency (in seconds) to be monitored when the new state is available.
Status=[interval]
Stop_job closes the executed job and exits the client.
The stop_job=immediate will immediately close the data pump job.
There are other commands:
Add_file adds a dump file to the dump file set.
Add_file=dirobjdumpfile-name
Continue_client returns to record mode. If it is idle, the job will be restarted.
Exit_client exits the client session and puts the job in a running state.
Help summarizes the interactive commands.
Kill_job Detach and delete jobs.
Parallel changes the number of active workers for the current job.
The number of Parallel=worker.
Start_job initiates the recovery of the current job.
Status at the default value (0) will display when the new state is available,
The job status of the frequency (in seconds) to monitor.
Status=[interval]
Stop_job closes the executed job and exits the client.
Stop_job=immediate will close immediately
This article fixed link: http://www.devba.com/index.php/archives/2395.html | Develop it

This article from the "Sky Fei" blog, declined to reprint!

Methods to terminate Imp/exp and EXPDP/IMPDP processes