>>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