Kontrola nastavení počtu CPU v databázi
SYS@orcp2> show parameter cpu
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cpu_count integer 4
parallel_threads_per_cpu integer 2
resource_manager_cpu_allocation integer 4
Spuštění datové pumpy paralelně
[oracle@orcp2 upgrade]$ expdp orc@orcp schemas=orc parallel=4 DUMPFILE=expdporc_%U.dmp directory=DATA_PUMP_DIR logfile=expdporc_16_10_2015.log FLASHBACK_TIME=SYSDATE
Export: Release 11.2.0.4.0 - Production on Fri Oct 16 16:34:16 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing optio
Starting "orc"."SYS_EXPORT_SCHEMA_01": orc/********@orcp schemas=orc parallel=4 DUMPFILE=expdporc_%U.dmp directory=DATA_PUMP_DIR logfile=expdporc_16_10_2015.log FLASHBACK_TIME=SYSDATE
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 49.53 GB
Kontrola běžících úloh
SYS@orcp2> select * from dba_datapump_jobs;
OWNER_NAME JOB_NAME
------------------------------ ------------------------------
OPERATION
--------------------------------------------------------------------------------
JOB_MODE
--------------------------------------------------------------------------------
STATE DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
------------------------------ ---------- ----------------- -----------------
orc SYS_EXPORT_SCHEMA_01
EXPORT
SCHEMA
EXECUTING
Kontrola jednotlivých workerů
[oracle@oda1 ~]$ expdp attach=SYS_EXPORT_SCHEMA_01
Export: Release 11.2.0.4.0 - Production on Fri Oct 16 16:38:53 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Username: orc
Password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing optio
Job: SYS_EXPORT_SCHEMA_01
Owner: orc
Operation: EXPORT
Creator Privs: FALSE
GUID: 223AB1424689C3AEE05332964C0A8957
Start Time: Friday, 16 October, 2015 16:34:27
Mode: SCHEMA
Instance: orcp1
Max Parallelism: 4
EXPORT Job Parameters:
Parameter Name Parameter Value:
CLIENT_COMMAND orc/********@orcp schemas=orc parallel=4 DUMPFILE=expdporc_%U.dmp directory=DATA_PUMP_DIR logfile=expdporc_16_10_2015.log FLASHBACK_TIME=SYSDATE
FLASHBACK_TIME 15-OCT-16 04:34:27 PM
State: EXECUTING
Bytes Processed: 6,956,896,872
Percent Done: 16
Current Parallelism: 4
Job Error Count: 0
Dump File: /cloudfs/export/expdporc_%u.dmp
Dump File: /cloudfs/export/expdporc_01.dmp
bytes written: 4,096
Dump File: /cloudfs/export/expdporc_02.dmp
bytes written: 2,335,690,752
Dump File: /cloudfs/export/expdporc_03.dmp
bytes written: 4,096
Dump File: /cloudfs/export/expdporc_04.dmp
bytes written: 4,638,478,336
Worker 1 Status:
Process Name: DW00
State: WORK WAITING
Worker 2 Status:
Process Name: DW00
State: WORK WAITING
Worker 3 Status:
Process Name: DW02
State: EXECUTING
Object Schema: orc
Object Name: BINDOCUMENT
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 1
Total Objects: 350
Completed Rows: 14,033
Worker Parallelism: 1
Worker 4 Status:
Process Name: DW01
State: EXECUTING
Object Schema: orc
Object Name: WEBSESSION
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 1
Total Objects: 350
Completed Rows: 831,513
Worker Parallelism: 1
Soubory generované na OS
-rw-r----- 1 oracle asmadmin 2335690752 Oct 16 16:37 expdporc_02.dmp
-rw-r----- 1 oracle asmadmin 4638478336 Oct 16 16:37 expdporc_04.dmp
-rw-r--r-- 1 oracle asmadmin 30487 Oct 16 16:37 expdporc_16_10_2015.log
-rw-r----- 1 oracle asmadmin 873730048 Oct 16 16:40 expdporc_03.dmp
-rw-r----- 1 oracle asmadmin 4740354048 Oct 16 16:40 expdporc_01.dmp
Komentáře
