I am doing export of full database with parallel=8 syntax but while checking through status its showing only one. ....Pls suggest.
Also one more point, if my putty session get closed, do my export job get terminiated . I suppose not ..Pls suggest.
Bytes Processed: 0
Current Parallelism: 8
Job Error Count: 0
Dump File: /dbexport/export/export_FULL_01.dmp
bytes written: 4,096
Dump File: /dbexport/export/export_FULL_%u.dmp
Worker 1 Status:
Process Name: DW00
Object Schema: SAPDAT
Object Name: /BI0/F0PA_C01
Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Completed Objects: 24,000
Worker Parallelism: 1
>>I am doing export of full database with parallel=8 syntax but while checking through status its showing only one. ....Pls suggest.
Do you have lob object on tables, how many dump file generated on your directory ?
>>Also one more point, if my putty session get closed, do my export job get terminiated . I suppose not ..Pls suggest.
No, it will run in background
1 use the scheduler of database control (or the scheduler in the database) and putty doesn't bother you anymore
2 or use 'nohup expdp .... &' and putty doesn't bother you anymore
3 or use (obsolete) cron
Oracle is using an algorithm in expdp to determine the number of parallel jobs. Your situation may not qualify for more than 1 job.
Senior Oracle DBA
Thanks for such a usefull replay ...
Yes, i am agree as my export job is right now seems doing estimation of blocks. I also read that gathering statistics, data are always done by only ONE worker....
This is the current status:
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA