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 -> temporary datafiles not being used

temporary datafiles not being used

From: Michael Jernigan <mjern92_at_yahoo.com>
Date: 4 Oct 2004 13:36:44 -0700
Message-ID: <d2befb10.0410041236.4e33a836@posting.google.com> 





I have a temporary tablespace with 4 data files of 1GB each.  The 1st
and 4th appear to be used.  There is no activity on the 2nd and 3rd
files.  Is that normal?  There is a lot of contention on the files
that are being used.  To reduce the contention would it be better to
have smaller files, but more of them?
Received on Mon Oct 04 2004 - 15:36:44 CDT












Original text of this message













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