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

Home -> Community -> Usenet -> c.d.o.server -> High TEMP tablespace IO rate

High TEMP tablespace IO rate

From: Paul A. Durnoff <dpa_at_mail.ru>
Date: Wed, 13 Sep 2000 11:33:19 +0400
Message-ID: <8pn7ql$m93$1@ns.metacom.ru> 






Hello,



Could somebody give me an advice:


I discovered that TEMP tablespace in one instance has very high number of IO
operations, about in three times higher than the DATA tablespace. Why? How
to fix it? May be it is not a problem?


All data is stored in DATA tablespace, indexes in INDX. All users have the
TEMP tablespace as temorary.



Thanks,


Paul A. Durnoff


dpa_at_mail.ru
Received on Wed Sep 13 2000 - 02:33:19 CDT












Original text of this message













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