Re: [suse-oracle] Using SSD as EMC FAST Cache vs. Oracle flash-cache

--===============0182936339==
Content-Type: multipart/alternative; boundary=e89a8f2345674d5f2704c400956a

--e89a8f2345674d5f2704c400956a
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Good day!
  We have established SSD drives (hitachi ams2300) in the ASM separate
DiskGroup and moved hot tables and indexes. That was enough for us. Oracle
flash cache work in Linux and Solaris only.

you need to test different options to choose the right option for you.




2012/7/4 Silviu Marin-Caea <[email protected]>

> We want to add SSD in our storage system for Oracle database 11gR2..
> there are two alternatives to consider:
>
> 1. Give the SSDs to the storage to use them as EMC FAST Cache. That is,
> the storage will see what are the "hot blocks" and use the SSDs for
> them. The operating system and Oracle do not need any special
> configuration, all the magic is in the storage.
>
> 2. Give the SSDs as /dev/sdX to Oracle to use as Oracle flash-cache
>
> http://www.oracle.com/technetwork/articles/systems-hardware-architecture/=
oracle-db-smart-flash-cache-175588.pdf
> This alternative means that we'd be forced to use Oracle Linux, because
> evil Oracle does not to share this feature with other distributions, AFAI=
K.
>
> Could the second option be that much faster to justify using Oracle's
> wares?  We'll do some testing, but it would be very useful to have some
> more information in advance.
>
> Thanks
> _______________________________________________
> suse-oracle mailing list
> [email protected]
> http://listx.novell.com/mailman/listinfo/suse-oracle
>



--=20
=D0=A1 =D1=83=D0=B2=D0=B0=D0=B6=D0=B5=D0=BD=D0=B8=D0=B5=D0=BC,
=D0=A2=D0=BA=D0=B0=D1=87=D0=B5=D0=BD=D0=BA=D0=BE =D0=9C=D0=B0=D0=BA=D1=81=
=D0=B8=D0=BC

--e89a8f2345674d5f2704c400956a
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<span id=3D"result_box" class=3D"" lang=3D"en"><span class=3D"hps">Good day=
!</span><br>=C2=A0 <span class=3D"hps"></span><span class=3D"hps">We have e=
stablished</span> <span class=3D"hps"></span><span class=3D"hps"></span><sp=
an class=3D"hps">SSD</span> <span class=3D"hps">drives (hitachi ams2300) in=
 the</span> <span class=3D"hps">ASM separate DiskGroup and</span> <span cla=
ss=3D"hps">moved</span> <span class=3D"hps"></span> <span class=3D"hps">hot=
</span> <span class=3D"hps">tables and indexes</span><span>.</span> <span c=
lass=3D"hps">That was enough</span> <span class=3D"hps">for us. Oracle flas=
h cache work in Linux and Solaris only.<br>
</span></span><span id=3D"result_box" class=3D"" lang=3D"en"><span class=3D=
"hps"><br>you need</span> <span class=3D"hps">to test</span> <span class=3D=
"hps">different</span> <span class=3D"hps">options to choose</span> <span c=
lass=3D"hps">the right</span> <span class=3D"hps">option</span> <span class=
=3D"hps">for you.<br>
<br></span></span><span id=3D"result_box" class=3D"" lang=3D"en"><span clas=
s=3D"hps"><br><br></span></span><br><div class=3D"gmail_quote">2012/7/4 Sil=
viu Marin-Caea <span dir=3D"ltr">&lt;<a href=3D"mailto:[email protected]=
" target=3D"_blank">[email protected]</a>&gt;</span><br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">We want to add SSD in our storage system for=
 Oracle database 11gR2..<br>
there are two alternatives to consider:<br>
<br>
1. Give the SSDs to the storage to use them as EMC FAST Cache. That is,<br>
the storage will see what are the &quot;hot blocks&quot; and use the SSDs f=
or<br>
them. The operating system and Oracle do not need any special<br>
configuration, all the magic is in the storage.<br>
<br>
2. Give the SSDs as /dev/sdX to Oracle to use as Oracle flash-cache<br>
<a href=3D"http://www.oracle.com/technetwork/articles/systems-hardware-arch=
itecture/oracle-db-smart-flash-cache-175588.pdf" target=3D"_blank">http://w=
ww.oracle.com/technetwork/articles/systems-hardware-architecture/oracle-db-=
smart-flash-cache-175588.pdf</a><br>

This alternative means that we&#39;d be forced to use Oracle Linux, because=
<br>
evil Oracle does not to share this feature with other distributions, AFAIK.=
<br>
<br>
Could the second option be that much faster to justify using Oracle&#39;s<b=
r>
wares? =C2=A0We&#39;ll do some testing, but it would be very useful to have=
 some<br>
more information in advance.<br>
<br>
Thanks<br>
_______________________________________________<br>
suse-oracle mailing list<br>
<a href=3D"mailto:[email protected]">[email protected]=
m</a><br>
<a href=3D"http://listx.novell.com/mailman/listinfo/suse-oracle" target=3D"=
_blank">http://listx.novell.com/mailman/listinfo/suse-oracle</a><br>
</blockquote></div><br><br clear=3D"all"><br>-- <br>=D0=A1 =D1=83=D0=B2=D0=
=B0=D0=B6=D0=B5=D0=BD=D0=B8=D0=B5=D0=BC,<div>=D0=A2=D0=BA=D0=B0=D1=87=D0=B5=
=D0=BD=D0=BA=D0=BE =D0=9C=D0=B0=D0=BA=D1=81=D0=B8=D0=BC</div><div><br></div=
><div><br></div><br>

--e89a8f2345674d5f2704c400956a--

--===============0182936339==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
suse-oracle mailing list
[email protected]
http://listx.novell.com/mailman/listinfo/suse-oracle

--===============0182936339==--