Solaris-Single node Vs Linux 3 nodes RAC

From: Sudhakar G Pillai <>
Date: Mon, 5 Nov 2012 07:25:34 -0800 (PST)
Message-ID: <>

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

Received on Mon Nov 05 2012 - 16:25:34 CET

Original text of this message