Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Solid state disks for Oracle?

RE: Solid state disks for Oracle?

From: Joseph Amalraj <joseph_at_amalrajinc.com>
Date: Thu, 9 Mar 2006 10:00:26 -0800 (PST)
Message-ID: <20060309180026.16361.qmail@web404.biz.mail.mud.yahoo.com>


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.       

Kevin Closson <kevinc_at_polyserve.com> wrote:   

>>As currently the optimizer uses the single block read time and
multiblock read time.

what?

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




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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US