Over 10 Million Study Resources Now at Your Fingertips

Download as :
Rating : ⭐⭐⭐⭐⭐
Price : $10.99
Pages: 2

Because the ora-cle sql interface bypassed this case


Chapter 19



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

POLICY privilege (either through a role or directly) are exempt from VPD and

Oracle label security enforcement in both direct and conventional path exports.

How It Works
Login account
Login Your Account
Add to cart
Add to Cart
Make payment
Document download
Download File
PageId: ELI1464115
Uploaded by :
Page 1 Preview
because the oracle sql interface bypassed this cas
Sell Your Old Documents & Earn Wallet Balance