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

Home -> Community -> Mailing Lists -> Oracle-L -> Locally managed Temporary tablespaces

Locally managed Temporary tablespaces

From: Peter Dixon <peterdixon001_at_hotmail.com>
Date: Thu, 09 Jun 2005 13:15:57 +0000
Message-ID: <BAY101-F21A8F484A295DDA4EF97FAFCFC0@phx.gbl> 





I have performed a healthcheck on our production database , I am running 
8.1.7.4 on hp11.11 with the database files running on a san (raid 5). I was 
surprised to see the average read time for the temporary tablespace as 826ms 
where all the other tablespaces in the database are around 10ms. Would it be 
a wise to move the temporary tablespace data files onto another sort of disk 
storage?



Peter Dixon


8i OCP



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


Received on Thu Jun 09 2005 - 09:21:03 CDT












Original text of this message













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