Re: Solaris-Single node Vs Linux 3 nodes RAC

From: Frits Hoogland <>
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
+31 6 53569942 <+31%206%2053569942>

Op 5 nov. 2012 om 16:44 heeft Sudhakar G Pillai <> het volgende geschreven:

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 ---------- ------------ 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 - 17:42:34 CET

Original text of this message