Increasing pga_aggregate_target helps in improving impdp performance
Please help me out with your valuable answer.
thanks in advance.
Yes it helps in improving the performance of the import job because the creation of indexes during the import will be fast as the indexes are usually in a sorted order and the sorting happens in pga. so that essentially means the larger the pga_aggregate_target the fewer the disk sorts during index creation and faster the import.
hope that helps
Sign up for STechies