Re: Solaris-Single node Vs Linux 3 nodes RAC
Date: Mon, 5 Nov 2012 17:42:34 +0100
Message-ID: <3152664060779101331_at_unknownmsgid>
Please use a sql trace at level 8 to understand what oracle is doing in both cases.
ASM is inherently DIO thus no buffering. If the database on Solaris does not do DIO, and there is much memory free, there is a chance the OS buffers the IO's
Frits Hoogland
http://fritshoogland.wordpress.com
frits.hoogland_at_gmail.com
+31 6 53569942 <+31%206%2053569942>
Op 5 nov. 2012 om 16:44 heeft Sudhakar G Pillai <sgnanap_at_yahoo.com> het volgende geschreven:
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 TotalWaited
- 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
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 05 2012 - 17:42:34 CET