Data Pump wishes (add this feature, please)
Hello, oracle,
1. i make the export-import very often and usually see the very long time in the create indexes stage. usually we have a many-cores server, but indexes are usually creating in one thread. this is especially true for enabling foreign keys and other constraints. is there a way to enable foreign keys in parallel, during export-import?
add this feature, please !
2.
As you know the optimizer uses statistics in their calculations.
And in my mind the statistics has the 2 levels: rules and data.
Rules - is, for example, column's names for which optimizer needs histogramms or column set for extended statistics and so on ...
1. i make the export-import very often and usually see the very long time in the create indexes stage. usually we have a many-cores server, but indexes are usually creating in one thread. this is especially true for enabling foreign keys and other constraints. is there a way to enable foreign keys in parallel, during export-import?
add this feature, please !
2.
As you know the optimizer uses statistics in their calculations.
And in my mind the statistics has the 2 levels: rules and data.
Rules - is, for example, column's names for which optimizer needs histogramms or column set for extended statistics and so on ...
1