| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: temp tablespace colesce
that's fine in oracle Database 9i release one but not in release 2.
In the last u only can have locally managed tablespaces where u can not use
pctincrease.
I'm trying to find a solution but couldn't yet.
Regards
PG
-----Original Message-----
Sent: sexta-feira, 16 de Maio de 2003 19:03
To: Multiple recipients of list ORACLE-L
If you meant shrink the amount used within the temp tablespace, you could try this. Our temp tablespaces are set at 10 percent normally. Altering it to 0 percent then immediately back to 10 percent usually cleans it up.
alter tablespace temp default storage(pctincrease 0);
alter tablespace temp default storage(pctincrease 10);
For the most part, I don't do this unless some runaway process or SQL filled the temp tablespace. Had a developer fill up a 2GB temp tablespace in a development DB just yesterday. Left me a nice ORA-1652: unable to extend temp segment by 750 in tablespace TEMP in the alert log!
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
jerome.whittle_at_scott.af.mil
618-622-4145
-----Original Message-----
What is the way to shrink temp tablespace . I tried alter tablespace colesce .. doesn't seems to work and I can't bring down the db .
-ak
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Paulo Gomes
INET: PGomes_at_Datinfor.pt
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri May 16 2003 - 13:40:48 CDT
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |