Solaris-Single node Vs Linux 3 nodes RAC
- From: Sudhakar G Pillai <sgnanap@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 5 Nov 2012 07:25:34 -0800 (PST)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
