Saturday, September 24, 2011

PARALLEL parameter in datapump


Nowadays DBA’s work with databases with gigabytes or terabytes of data. Exporting data can be a very time consuming job when we needed to export lots of data in a short period of time. Datapump EXPDP has the ability to export data as compressed format, thus achieving faster write times, but this will use more processor time. Datapump also has the ability to open several parallel write channels to improve the overall export time.

Today i’ll explain how parallel parameter works. Parallel allows you to launch several dump processes, thus exporting data much faster. You can specify the numbers of processes you want to launch by setting parallel=n. You can specify the filenames of each processes individually or the filename can contain a substitution variable (%U), which implies that multiple files may be generated. The substitution variable is expanded in the resulting filenames into a 2-digit, fixed-width, incrementing integer starting at 01 and ending at 99.

DEMO:

We will here export the scott schemas with parallel=2 thus two dump files will be created.

SQL> host expdp system/sys schemas=scott dumpfile=scott%u.dmp parallel=2

Export: Release 11.2.0.1.0 - Production on Sat Sep 24 10:31:17 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_03":  system/******** schemas=scott dumpfile=scott%u.dmp parallel=2
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 256 KB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
. . exported "SCOTT"."DEPT"                              5.937 KB       4 rows
. . exported "SCOTT"."EMP"                               8.570 KB      14 rows
. . exported "SCOTT"."SALGRADE"                          5.867 KB       5 rows
. . exported "SCOTT"."TEST"                              5.429 KB       2 rows
. . exported "SCOTT"."BONUS"                                 0 KB       0 rows
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_03" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_03 is:
  D:\APP\BISHWANATH\ADMIN\DELHI\DPDUMP\SCOTT01.DMP
  D:\APP\BISHWANATH\ADMIN\DELHI\DPDUMP\SCOTT02.DMP
Job "SYSTEM"."SYS_EXPORT_SCHEMA_03" successfully completed at 10:32:11


Now we drop scott and import it again.You notice that during import also we don't need to mention all the dumpfile names instead just put the parallel parameter.

SQL> drop user scott cascade;

User dropped.


SQL> host impdp system/sys schemas=scott dumpfile=scott%u.dmp parallel=2

Import: Release 11.2.0.1.0 - Production on Sat Sep 24 10:33:27 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01":  system/******** schemas=scott dumpfile=scott%u.dmp parallel=2
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "SCOTT"."DEPT"                              5.937 KB       4 rows
. . imported "SCOTT"."EMP"                               8.570 KB      14 rows
. . imported "SCOTT"."SALGRADE"                          5.867 KB       5 rows
. . imported "SCOTT"."TEST"                              5.429 KB       2 rows
. . imported "SCOTT"."BONUS"                                 0 KB       0 rows
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully completed at 10:33:35


Enjoy:-)

31 comments:

Anonymous said...

Why users still make use of to read news papers when in this technological globe
all is accessible on web?

my homepage how to Lose weight Fast for women

Anonymous said...

Greetings! Very helpful advice within this post!

It is the little changes that produce the greatest changes.
Thanks a lot for sharing!

Also visit my weblog - mont blanc replica pens

Anonymous said...

I don't know whether it's just me or if everyone else encountering problems with your blog.
It appears like some of the written text within your content are running off the screen. Can someone else
please comment and let me know if this is happening to
them too? This may be a problem with my web
browser because I've had this happen before. Thank you

My page - line cookie run cheats

Anonymous said...

Excellent article. Keep posting such kind of info on your blog.
Im really impressed by your site.
Hello there, You've performed an excellent job.
I'll certainly digg it and individually suggest
to my friends. I am sure they'll be benefited from this website.


Here is my webpage - Free league of legends Skin Codes By FreeLeagueOfLegendsCodes.com

Anonymous said...

I visited various blogs however the audio feature for audio songs current
at this site is really fabulous.

my webpage :: How To Hack Facebook Accounts 2014

Anonymous said...

Hello to all, how is everything, I think every
one is getting more from this web site, and your views are pleasant for
new users.

my weblog: last longer, ,

Anonymous said...

I am curious tο finԀ ouut wɦat blog platform ƴou happen to be
working with? I'm experiencing some minor security prоblemѕ with my latest site and I'd like to find something more
risk-freе. Do you have any recommendations?

Also visit my website - Maillot Equipe de France

Anonymous said...

It's really very difficult in this active life to listen news on TV, therefore I only use
the web for that purpose, and take the most recent information.

Here is my web site - After Effects Explosion

Anonymous said...

When I initially commented I clicked the "Notify me when new comments are added" checkbox and now
each time a comment is added I get four e-mails with the same comment.
Is there any way you can remove me from that service? Appreciate it!


Here is my web site: after effects intro template free ()

Anonymous said...

Is it hard to hear the dialogue above the background noise.
'The Croods' is compatible only with i - Phone 3GS+,
i - Pod touch(4th generation+), i - Pad 2+ and i -
Pad mini. And players both charge (obviously being
played in special op's mode) through the flying rubble.


Here is my web site :: Clash of Clans Bot

Anonymous said...

Hi, i think that i saw you visited my blog so i came to “return the favor”.I am attempting
to find things to improve my site!I suppose its ok to use a few
of your ideas!!

Look at my page: ebook barato

Anonymous said...

"We're moving to free up a substantial amount of spectrum for Wi - Fi to relieve Wi - Fi congestion and improve Wi - Fi speeds at conferences, airports an ultimately people's homes," Genachowski said on stage at the event, according to
a report from the Denver Post. A VPN is one of the best
ways to have remote access to your home machine and maintain a secure
network connection while using highly insecure public Wi-fi hotspots.
Jan Legnitto is an investigative journalist and documentary producer who write about criminal justice and intelligence issues.


Here is my homepage free wifi gratuit ()

Anonymous said...

chanel handbags sale
My programmer is trying to convince me to move to .net from PHP.
I have always disliked the idea because of the costs.
But he's tryiong none the less. I've been using Movable-type on various websites for about
a year and am concerned about switching to another platform.
I have heard great things about blogengine.net.
Is there a way I can transfer all my wordpress posts into it?
Any help would be really appreciated!

Anonymous said...

What a stuff of un-ambiguity and preserveness of valuable experience
regarding unpredicted emotions.

my web blog how do you pass level 80 on farm heroes saga

Anonymous said...

Heya! I know this is somewhat off-topic however I needed to ask.

Does operating a well-established blog such as
yours require a lot of work? I am completely new to writing a blog but
I do write in my journal everyday. I'd like to start a blog so I can share my experience
and feelings online. Please let me know if you have any ideas or tips for
new aspiring blog owners. Appreciate it!

Also visit my blog ... Search engine marketing basics pdf

Anonymous said...

Howdy! This post couldn't be written any better!

Reading this post reminds me of my previous room mate!
He always kept talking about this. I will forward this page to him.
Pretty sure he will have a good read. Thank you for sharing!


my homepage - clash of clans hack android

Anonymous said...

Mike Ditka can still be seen on television as a football commentator and in commercials,
 still as fiery and unique as ever. Who will ever forget Mc - Mahon mooning a helicopter or insulting the
female population of New Orleans during the weeks
prior to Super Bowl XX. Don't forget packages of marshmallows for the campfires or gallons of milk for the breakfasts.


Look into my blog :: Monster Legends hack (www.dailymotion.com)

Anonymous said...

If you are going for best contents like I do, simply pay
a visit this web site every day as it presents quality contents, thanks

My webpage Tantric massage ()

Anonymous said...

certainly like your web-site but you need to check the spelling on quite a few of your
posts. Several of them are rife with spelling issues and
I to find it very troublesome to tell the truth nevertheless I
will certainly come again again.

Also visit my web-site ... dead trigger 2 hack

ravdijaj said...

Greetings! Very helpful advice within this post!

Thank you

Anonymous said...

You are really explained very well about Payroll, but you know there are lots of cloud based payroll accounting software’s are available in the market that can make your accounting hassle free. Currently I am using Nomisma accounting software for Bookkeeping and payroll. I recommend you to go ahead with Nomisma Payroll accounting software to easy accounting.

seocom said...


ارخص شركة عزل اسطح بالدمام 0546970480 المستقبل


الكثير يعاني من مشكلة تراكم الأمطار فوق أسطح المنازل تحديداً في فصل الشتاء، والذي يؤدي إلى العديد من المشاكل التي تحدث للأبنية الداخلية والأبنية الخرسانية للمنازل وقد تتسرب المياه وتتغلل داخل سطح المنزل مما يؤدي إلى حدوث بعض المشاكل وتسرب المياه إلى داخل المنزل بشكل ظاهر والذي يسبب الإزعاج لصاحب المنزل.

ارخص شركة عزل اسطح بالدمام

كما يتسبب أيضاً تسرب المياه الى بعض التشققات في الأسطح وتفسد الدهانات الموجودة بالسقف ويجعل شكلها سىء جداً، وخلال فصل الصيف وأشعة الشمس القوية تتسبب في إزعاج سكان المنزل مما تجعل حرارة المنزل مرتفع جداً ويتسبب في الإحساس بالاختناق والتعرق، فلتخلص من كل هذه المشاكل لابد من عملية عزل للأسطح .

تعتبر عملية عزل الأسطح مهمة للغاية ومن أهم الشركات المخصصة في هذا المجال المستقبل
شركة عزل فوم بالدمام
التي تقدم الخدمة لكافة أنواع الأسطح، وتهتم
شركة عزل اسطح بالدمام
بأعمال العزل الحرارية والمائية للأسطح، وتعتمد الشركة على مجموعة من العاملين الذين يتمتعون بخيرة وكفاءة عالية للتعامل مع الأنواع المتعددة للعزل الحراري و العزل المائي لاننا
شركة عزل حرارى بالدمام
و
شركة عزل مائى بالدمام
شركة عوازل الدمام
شركات العزل المائي بالدمام
شركات العزل الحراري بالدمام


اسعار عزل الفوم
اسعار الواح الفوم العازل

Unknown said...

fifa live stream 2018
"Fifa Live 2018"

jeje said...

coach outlet online
mulberry bags
michael kors handbags sale
polo ralph lauren
nike blazer low
pandora outlet
michael kors uk
pandora
air huarache
coach outlet store online

Rusa samira said...
This comment has been removed by the author.
Unknown said...

nike sneakers for men
yeezy boost 350
retro jordans
links of london
balenciaga shoes
coach outlet
nba jerseys
kd shoes
fila shoes
Kanye West shoes

Unknown said...

Nice Post..Thanks for Sharing..
erp in chennai
erp providers in chennai
SAP B1 implementation
SAP S/4 Hana implementation
SAP R3 implementation
hr outsourcing

umbrellas rawadaltaswir said...

الان نقدم لكم افضل شركة تركيب مظلات في السعودية حيث يتواجد مظلات للبيع من اجود الانواع ويتوفر ايضا سواتر قماش فاخرة لحماية السيارات كما يوجد هناجر الرياض لحفظ المنتجات واخيرا بيوت شعر الرياض لاعطاء المنزل فخامة ورُقي .

Nashwa Mostafa said...

شركة بيع طارد وشبك الحمام
طارد الحمام للمكيفات
طارد الحمام من المنزل
سلك طارد الحمام
تركيب طارد الحمام بالمدينه


طارد الحمام بالمدينة المنورة
شركات طرد الحمام
افضل شركات تركيب طارد الحمام بالمدينة المنورة
شركة تركيب طارد الحمام بالمدينة المنورة ومانع الطيور

yanmaneee said...

adidas ultra
nmd
converse outlet store
yeezy shoes
cheap jordans
yeezy boost 350 v2
kyrie 5
yeezy
nike shox for men
adidas ultra boost

dreamcare said...

It’s very nice blog! Shoe Bags