RE: Solid state disks for Oracle?

  • From: Joseph Amalraj <joseph@xxxxxxxxxxxxxx>
  • To: kevinc@xxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 9 Mar 2006 10:00:26 -0800 (PST)

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@xxxxxxxxxxxxx> wrote:
  
>>As currently the optimizer uses the single block read time and
multiblock read time. 

what?
--
//www.freelists.org/webpage/oracle-l



Other related posts: