RE: Solid state disks for Oracle?

From: Joseph Amalraj <joseph_at_amalrajinc.com>
Date: Thu, 9 Mar 2006 10:56:25 -0800 (PST)
Message-ID: <20060309185625.64103.qmail@web402.biz.mail.mud.yahoo.com>

Texas Memory Systems are offering upto 1 TB SSD systems.   Prices of these systems may drop is future. Putting some tablespaces on SSDs in such a case, could be considered.   

Kevin Closson <kevinc_at_polyserve.com> wrote:

      Show me where that changes a plan.    

  No matter, the model for deploying SSD in conjunction   with Oracle is not meant for tablespaces anyway. The   primary focus for SSD is transaction logging acceleration.    

  Any shop that is languishing over redo writing latency is   doing so unnecessarily. The technology exists to   serve up SSD via NFS to any large number of servers   in the enterprise. The model is NFS->SAN Gateway->SSD   and it is very very fast and supports extremely high   bandwidth...and is OSCP certified...    

  Oh, yeah, I'm sure there is some Oracle glossy somewhere   that says ASM on round-spinning-thingies is faster than SSD...    

  :-)              

---

  From: Joseph Amalraj [mailto:joseph_at_amalrajinc.com] Sent: Thursday, March 09, 2006 10:00 AM
To: kevinc_at_polyserve.com; oracle-l_at_freelists.org Subject: RE: Solid state disks for Oracle?   

  when dbms_stats.gather_system_stats is run then   time to read a single block , and
  time to read multiple blocks at one time is   stored is aux_stats$ table, which is used by the optimizer.         

--

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 09 2006 - 12:56:25 CST