You might want to start here: http://www.oracle.com/technetwork/articles/datawarehouse/twp-parallel-execution-fundamentals-133639.pdf heavily using PQ doesn't seem to be synonymous with OLTP. ________________________________ From: Sanjay Mishra <smishra_97@xxxxxxxxx> To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx> Sent: Wednesday, October 12, 2011 1:23 PM Subject: RAC PARALLEL Hi We have one environment on Sun Infrastructure where we are planning to move to RAC on 11g. So move is from non-RAC to 4-Node 11g R2 RAC. Database is OLTP, Partitioned Tables/Indexes and Apps is using heavily PARALLEL and PARALLEL_INDEX hints. What is the point to consider for the setup. Saw that we hit some big performance in Test setup and look like it may be due to Paralell setup. any good sugestion or best practices on RAC setup TIA Sanjay -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l