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>
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-lReceived on Mon Nov 05 2012 - 16:25:34 CET