Sort_area_size and pga_aggregate_target

From: Khan, Muhammad <>
Date: Wed, 22 Jul 2020 15:32:13 +0000
Message-ID: <>

Hi everyone,

This is related to Oracle v 12.1 on 2 node RAC on AIX. I've a heavy duty import process (impdp). Data doesn't that long. However the index creation taking way long, roughly around 7-8 hours. As per original setting:

pga_aggregate_target = 0
Sort_area_size = 2136746229

Tried setting pga_aggregate_target to 8G but the index creation prolonged few minutes more than original. This is standard edition so cant use parallel. Any idea of what optimal values for the two parameters may help in this whole process?


The information contained in this electronic e-mail transmission and any attachments are intended only for the use of the individual or entity to whom or to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this communication is not the intended recipient, or the employee or agent responsible for delivering this communication to the intended recipient, you are hereby notified that any dissemination, distribution, copying or disclosure of this communication and any attachment is strictly prohibited. If you have received this transmission in error, please notify the sender immediately by telephone and electronic mail, and delete the original communication and any attachment from any computer, server or other electronic recording or storage device or medium. Receipt by anyone other than the intended recipient is not a waiver of any attorney-client, physician-patient or other privilege.

Received on Wed Jul 22 2020 - 17:32:13 CEST

Original text of this message