Impdp example using attach increase parallel from 10 to 17
[oracle@TEST_hostname <Dir>]$ impdp attach=SYS_IMPORT_SCHEMA_05
Export: Release 19.0.0.0.0 - Production on Tue Aug 23 10:08:27 2022
Version 19.16.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Username: / as sysdba
Import: Release 19.0.0.0.0 - Production on Tue Aug 23 10:08:49 2022
Version 19.16.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Username: / as sysdba
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Job: SYS_IMPORT_SCHEMA_05
Owner: SYS
Operation: IMPORT
Creator Privs: TRUE
Start Time: Monday, 22 August, 2022 8:18:03
Mode: SCHEMA
Instance: TEST_DB
Max Parallelism: 10
Timezone: -05:00
Timezone version: 32
Endianness: LITTLE
NLS character set: AL32UTF8
NLS NCHAR character set: AL16UTF16
EXPORT Job Parameters:
Parameter Name Parameter Value:
CLIENT_COMMAND "/******** AS SYSDBA" parfile=expdp_.par
LOGTIME ALL
METRICS 1
TRACE 0
IMPORT Job Parameters:
Parameter Name Parameter Value:
CLIENT_COMMAND "/******** AS SYSDBA" parfile=impdp_.par
LOGTIME ALL
METRICS 1
TRACE 0
State: EXECUTING
Bytes Processed: 107,367,434,768
Percent Done: 99
Current Parallelism: 10
Job Error Count: 0
Job heartbeat: 1511
Dump File: <Directory>%u.dmp
Dump File: <Directory>01.dmp
Dump File: <Directory>02.dmp
Dump File: <Directory>03.dmp
Dump File: <Directory>04.dmp
Dump File: <Directory>05.dmp
Dump File: <Directory>06.dmp
Dump File: <Directory>07.dmp
Dump File: <Directory>08.dmp
Dump File: <Directory>09.dmp
Dump File: <Directory>10.dmp
Dump File: <Directory>11.dmp
Dump File: <Directory>12.dmp
Dump File: <Directory>13.dmp
Dump File: <Directory>14.dmp
Dump File: <Directory>15.dmp
Dump File: <Directory>16.dmp
Dump File: <Directory>17.dmp
Worker 1 Status:
Instance ID: 1
Instance name: TEST_DB
Host name: TEST_hostname
Access method: direct_path
Object start time: Monday, 22 August, 2022 8:51:57
Object status at: Monday, 22 August, 2022 8:51:57
Process Name: DW00
State: WORK WAITING
Worker 2 Status:
Instance ID: 1
Instance name: TEST_DB
Host name: TEST_hostname
Access method: direct_path
Object start time: Monday, 22 August, 2022 8:51:59
Object status at: Monday, 22 August, 2022 8:51:59
Process Name: DW01
State: WORK WAITING
Worker 3 Status:
Instance ID: 1
Instance name: TEST_DB
Host name: TEST_hostname
Access method: direct_path
Object start time: Monday, 22 August, 2022 8:50:09
Object status at: Monday, 22 August, 2022 8:50:09
Process Name: DW02
State: WORK WAITING
Worker 4 Status:
Instance ID: 1
Instance name: TEST_DB
Host name: TEST_hostname
Object start time: Monday, 22 August, 2022 8:18:22
Object status at: Monday, 22 August, 2022 8:18:22
Process Name: DW03
State: EXECUTING
Object Schema: VRAADMIN
Object Name: PROPERTY_VALUES
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 7
Completed Rows: 3,424,119
Completed Bytes: 305,046,291,952
Percent Done: 63
Worker Parallelism: 8
Worker 5 Status:
Instance ID: 1
Instance name: TEST_DB
Host name: TEST_hostname
Access method: direct_path
Object start time: Monday, 22 August, 2022 8:50:14
Object status at: Monday, 22 August, 2022 8:50:14
Process Name: DW04
State: WORK WAITING
Worker 6 Status:
Instance ID: 1
Instance name: TEST_DB
Host name: TEST_hostname
Access method: direct_path
Object start time: Monday, 22 August, 2022 8:58:33
Object status at: Monday, 22 August, 2022 8:58:33
Process Name: DW05
State: WORK WAITING
Worker 7 Status:
Instance ID: 1
Instance name: TEST_DB
Host name: TEST_hostname
Access method: direct_path
Object start time: Monday, 22 August, 2022 8:50:14
Object status at: Monday, 22 August, 2022 8:50:14
Process Name: DW06
State: WORK WAITING
Worker 8 Status:
Instance ID: 1
Instance name: TEST_DB
Host name: TEST_hostname
Access method: direct_path
Object start time: Monday, 22 August, 2022 8:51:57
Object status at: Monday, 22 August, 2022 8:51:57
Process Name: DW07
State: WORK WAITING
Worker 9 Status:
Instance ID: 1
Instance name: TEST_DB
Host name: TEST_hostname
Access method: direct_path
Object start time: Monday, 22 August, 2022 8:51:59
Object status at: Monday, 22 August, 2022 8:51:59
Process Name: DW08
State: WORK WAITING
Worker 10 Status:
Instance ID: 1
Instance name: TEST_DB
Host name: TEST_hostname
Access method: direct_path
Object start time: Monday, 22 August, 2022 8:50:09
Object status at: Monday, 22 August, 2022 8:50:09
Process Name: DW09
State: WORK WAITING
Import> parallel=17
Import> status
Job: SYS_IMPORT_SCHEMA_05
Operation: IMPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 107,367,434,768
Percent Done: 99
Current Parallelism: 17
Job Error Count: 0
Job heartbeat: 2
Dump File: <Directory>%u.dmp
Dump File: <Directory>01.dmp
Dump File: <Directory>02.dmp
Dump File: <Directory>03.dmp
Dump File: <Directory>04.dmp
Dump File: <Directory>05.dmp
Dump File: <Directory>06.dmp
Dump File: <Directory>07.dmp
Dump File: <Directory>08.dmp
Dump File: <Directory>09.dmp
Dump File: <Directory>10.dmp
Dump File: <Directory>11.dmp
Dump File: <Directory>12.dmp
Dump File: <Directory>13.dmp
Dump File: <Directory>14.dmp
Dump File: <Directory>15.dmp
Dump File: <Directory>16.dmp
Dump File: <Directory>17.dmp
Worker 1 Status:
Instance ID: 1
Instance name: TEST_DB
Host name: TEST_hostname
Access method: direct_path
Object start time: Monday, 22 August, 2022 8:51:57
Object status at: Monday, 22 August, 2022 8:51:57
Process Name: DW00
State: WORK WAITING
Worker 2 Status:
Instance ID: 1
Instance name: TEST_DB
Host name: TEST_hostname
Access method: direct_path
Object start time: Monday, 22 August, 2022 8:51:59
Object status at: Monday, 22 August, 2022 8:51:59
Process Name: DW01
State: WORK WAITING
Worker 3 Status:
Instance ID: 1
Instance name: TEST_DB
Host name: TEST_hostname
Access method: direct_path
Object start time: Monday, 22 August, 2022 8:50:09
Object status at: Monday, 22 August, 2022 8:50:09
Process Name: DW02
State: WORK WAITING
Worker 4 Status:
Instance ID: 1
Instance name: TEST_DB
Host name: TEST_hostname
Object start time: Monday, 22 August, 2022 8:18:22
Object status at: Monday, 22 August, 2022 8:18:22
Process Name: DW03
State: EXECUTING
Object Schema: VRAADMIN
Object Name: PROPERTY_VALUES
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 7
Completed Rows: 3,424,119
Completed Bytes: 305,046,291,952
Percent Done: 63
Worker Parallelism: 8
Worker 5 Status:
Instance ID: 1
Instance name: TEST_DB
Host name: TEST_hostname
Access method: direct_path
Object start time: Monday, 22 August, 2022 8:50:14
Object status at: Monday, 22 August, 2022 8:50:14
Process Name: DW04
State: WORK WAITING
Worker 6 Status:
Instance ID: 1
Instance name: TEST_DB
Host name: TEST_hostname
Access method: direct_path
Object start time: Monday, 22 August, 2022 8:58:33
Object status at: Monday, 22 August, 2022 8:58:33
Process Name: DW05
State: WORK WAITING
Worker 7 Status:
Instance ID: 1
Instance name: TEST_DB
Host name: TEST_hostname
Access method: direct_path
Object start time: Monday, 22 August, 2022 8:50:14
Object status at: Monday, 22 August, 2022 8:50:14
Process Name: DW06
State: WORK WAITING
Worker 8 Status:
Instance ID: 1
Instance name: TEST_DB
Host name: TEST_hostname
Access method: direct_path
Object start time: Monday, 22 August, 2022 8:51:57
Object status at: Monday, 22 August, 2022 8:51:57
Process Name: DW07
State: WORK WAITING
Worker 9 Status:
Instance ID: 1
Instance name: TEST_DB
Host name: TEST_hostname
Access method: direct_path
Object start time: Monday, 22 August, 2022 8:51:59
Object status at: Monday, 22 August, 2022 8:51:59
Process Name: DW08
State: WORK WAITING
Worker 10 Status:
Instance ID: 1
Instance name: TEST_DB
Host name: TEST_hostname
Access method: direct_path
Object start time: Monday, 22 August, 2022 8:50:09
Object status at: Monday, 22 August, 2022 8:50:09
Process Name: DW09
State: WORK WAITING
Import>
No comments:
Post a Comment