RE: limit space usage in temporary tablespace
- From: "Anthony Molinaro" <amolinaro@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>, <ORACLE-L@xxxxxxxxxxxxx>,<oracledba@xxxxxxxxxxx>, <oracle-databases@xxxxxxxxxxxxxxx>,<oracle-rdbms@xxxxxxxxxxxxxxx>
- Date: Fri, 7 May 2004 12:22:37 -0400
Jeff,
Just put a maxsize on the tempfile when you create it, or alter it:
alter database tempfile '/temp01.dbf' autoextend on maxsize 1024m;
that lets it grow to 1gb an no more.
- ant
-----Original Message-----
From: Jeffrey Beckstrom [mailto:JBECKSTROM@xxxxxxxxx]=20
Sent: Friday, May 07, 2004 12:18 PM
To: oracle-l@xxxxxxxxxxxxx; ORACLE-L@xxxxxxxxxxxxx;
oracledba@xxxxxxxxxxx; oracle-databases@xxxxxxxxxxxxxxx;
oracle-rdbms@xxxxxxxxxxxxxxx
Subject: limit space usage in temporary tablespace
With 8.1.7 and dictionary managed permanent temporary tablespace, we
have maxextents set to 505. Therefore, if someone starts to utilize all
of our temp space they will hit maxextents long before taking all the
space. This guards against the "bad" one time query.=20
With 9.2, we will switch to locally managed temporary tablespaces. As
such, there is no maxextents value. Is it possible to limit how much
space a given connection uses with these types of tablespaces or will a
user just "grab it all".
=20
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
