Re: Solaris-Single node Vs Linux 3 nodes RAC

From: pier paolo Bruno <pbrunoster_at_gmail.com>
Date: Mon, 5 Nov 2012 16:59:14 +0100
Message-ID: <CA+dM1yNWJM71a6T2Uj=nUjCDeXhA6f1MWr4YdVtXR7iMEPTdOw_at_mail.gmail.com>

I'd control wait event of IO from awr , avg time for db_file sequential read and for db file scattered read ... in any case I would look at awr reports even to evaluate the load of the 2 system . ciao
2012/11/5 Sudhakar G Pillai <sgnanap_at_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-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Nov 05 2012 - 16:59:14 CET