Home » RDBMS Server » Server Utilities » performance diff in exp & expdp
performance diff in exp & expdp [message #459229] Fri, 04 June 2010 01:36 Go to next message
Riyasbasha
Messages: 25
Registered: March 2010
Junior Member
Hi All

I export a table using exp utility it take 30 mins to complete the export.
The same i have done in expdp utility it take 10 mins to complete the export.
How it happens?
can any one help me.
Re: performance diff in exp & expdp [message #459230 is a reply to message #459229] Fri, 04 June 2010 01:38 Go to previous messageGo to next message
Michel Cadot
Messages: 67946
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
2 different tools, each one has its pros and cons, you found an advantage for your case.
Now if you want more you have to detail what you did including where you launch your commands, the syntax you use, the versions and so on.

Regards
Michel

[Updated on: Fri, 04 June 2010 01:40]

Report message to a moderator

Re: performance diff in exp & expdp [message #459233 is a reply to message #459230] Fri, 04 June 2010 01:40 Go to previous messageGo to next message
Riyasbasha
Messages: 25
Registered: March 2010
Junior Member
sorry michel, i cant get you properly can u give me in other words
Re: performance diff in exp & expdp [message #459241 is a reply to message #459233] Fri, 04 June 2010 02:10 Go to previous message
Michel Cadot
Messages: 67946
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
expdp and exp are 2 different tools, no common code, no common file format, nothing in common, so comparing their performances is meaningless.

Regards
Michel
Previous Topic: ora-00600
Next Topic: ORA-03120: two-task conversion routine: integer overflow
Goto Forum:
  


Current Time: Fri Sep 17 07:54:03 CDT 2021