Ahhh, this is windows. >>> amolinaro@xxxxxxxx 5/7/04 12:31:31 PM >>> Jeff, The maxsize I posted is an attribute of the file, not the segments. I currently use maxsize and it's fine. Give it a shot on one of your=20 test/dev instances, if it doesn't work as advertised lemme know.=20 Regards, - ant -----Original Message----- From: Jeffrey Beckstrom [mailto:JBECKSTROM@xxxxxxxxx]=20 Sent: Friday, May 07, 2004 12:29 PM To: oracle-l@xxxxxxxxxxxxx; ORACLE-L@xxxxxxxxxxxxx; oracledba@xxxxxxxxxxx; Anthony Molinaro; oracle-databases@xxxxxxxxxxxxxxx; oracle-rdbms@xxxxxxxxxxxxxxx Subject: RE: limit space usage in temporary tablespace What about this note: =20 This behavior is documented. =20 MAXEXTENTS is ignored for temporary tablespaces. As stated in the =20 SQL Reference guide, only NEXT is noted for temporary tablespaces.=20 >>> amolinaro@xxxxxxxx 5/7/04 12:22:37 PM >>> 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]=3D20=20 Sent: Friday, May 07, 2004 12:18 PM To: oracle-l@xxxxxxxxxxxxx; ORACLE-L@xxxxxxxxxxxxx; oracledba@xxxxxxxxxxx; oracle-databases@xxxxxxxxxxxxxxx; oracle-rdbms@xxxxxxxxxxxxxxx=20 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.=3D20 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". =3D20 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=20 ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx=20 put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/=20 FAQ is at //www.freelists.org/help/fom-serve/cache/1.html=20 ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx=20 put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/=20 FAQ is at //www.freelists.org/help/fom-serve/cache/1.html=20 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------