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 -> Re: Temp Tablespace very large oracle 9ir2

Re: Temp Tablespace very large oracle 9ir2

From: <aj70000_at_hotmail.com>
Date: 29 Nov 2005 16:26:31 -0800
Message-ID: <1133310391.129214.249040@g49g2000cwa.googlegroups.com> 





so if the query is running it may not be processed in an OLTP kind of
env. if the maxsize is reached. What is a better approach for temp
tablespace?



Allow it to autoextend and the drop and recreate the tablespace if it
goes beyond a threshold (let us say 50 GB)
or


Classify maxsize on the datafile and wait for the complain.



Thanks again


AJ
Received on Tue Nov 29 2005 - 18:26:31 CST












Original text of this message













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