Solaris-Single node Vs Linux 3 nodes RAC

From: Sudhakar G Pillai <sgnanap_at_yahoo.com>
Date: Mon, 5 Nov 2012 07:25:34 -0800 (PST)
Message-ID: <1352129134.83473.YahooMailNeo_at_web140603.mail.bf1.yahoo.com>


All,
I appreciate if you could shed some light on which direction to go. I have Solaris non-rac database running with 26GB SGA ( PDB-NONRAC(Solaris)) and 3 node RAC database in Linux with 100GB SGA ( PDB-RAC ) . One of our program runs 3 times slower on RAC vs Soalris. Same SQL code , same plan, and  same oracle version etc. Solaris has file system with Veritas LVM and Linux has ASM.  Here is the output of 10046: SQL ID: 9txtqr9tdkcbs
  Event waited on                             Times   Max. Wait  Total Waited
                                         ----------------------------------------   Waited  ----------  ------------

PDB-NONRAC(Solaris)                     db file sequential read                    413468        0.32          234.99
PDB-RAC(LINUX)                          db file sequential read                    434173        0.50         2138.24

Is it Veritas's LVM caching playing the role here vs no-caching in ASM?
 
 Thank you,

Sudhakar G Pillai

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 05 2012 - 16:25:34 CET

Original text of this message