Re: RAC PARALLEL

From: Job Miller <jobmiller_at_yahoo.com>
Date: Wed, 12 Oct 2011 10:56:33 -0700 (PDT)
Message-ID: <1318442193.44976.YahooMailNeo_at_web162018.mail.bf1.yahoo.com>

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_at_yahoo.com> To: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> 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

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Oct 12 2011 - 12:56:33 CDT