: hi all:
: in my company, there are 10mb data to export , but it take me
: about 10 hours to export , does it normal ? or have someway to speed
: up the export speed ? thanks
:
: oracle 7.1.3 for DG
10 hours is *way* too long to export 10M of data. Some ways to speed it up
are listed below:
1) Specify an export file in a volume directory OTHER than database-related
volumes.
Bonus for a separate controller and/or disk
2) Break the export into many parallel exports, each one exporting different
tables/owners.
3) Increase the buffer size for the export (exp buffer=xxxxx)
4) I am not as familiar with 7.1.3, but if possible use DIRECT=Y mode for
the direct path execution
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 115+ Oracle tips, visit my Web Page: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page