Re: Solaris-Single node Vs Linux 3 nodes RAC
- From: pier paolo Bruno <pbrunoster@xxxxxxxxx>
- To: sgnanap@xxxxxxxxx
- Date: Mon, 5 Nov 2012 16:59:14 +0100
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@xxxxxxxxx>
>
> 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
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
