Export done in US7ASCII character set and AL16UTF16 NCHAR character set
About to export specified tables via Direct Path ...
The best way to speed up exports is to use the following parameter:
|Backup and Restore Using Export and Import|
larger buffer reduces the number of OCI execute calls required to fetch the same num-ber of rows. The default buffer size is 64K.
It’s not unusual to see a 30 to 50 percent reduction in export time through the use of direct path export compared to a conventional path export of the same data. The RECORDLENGTH parameter can be used to tune the performance of direct path export. The maximum value is 64K. Experiments indicate that changing the setting doesn’t make a very significant difference to export performance, maybe giving an extra 5 to 10 percent reduction in elapsed time.
problems in this case, avoiding direct�y for export should fix the problem.
Security Considerations for
POLICY privilege (either through a role or directly) are exempt from VPD and
Oracle label security enforcement in both direct and conventional path exports.