Hi Tamil,

Thanks for your response. We are using PGA and have set the pga_aggregate_target to 25165824. I will have the bug ids you have given. Thank You for that. How would you use the DBMS_PIPE in conjuction with the query?.

Thanks in advance,
Chucks