Re: Clean temporary tablespace
What version are you on? If less then 9i use the method posted by Hemant K Chitale. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 6:44 AM Well, I mean that OS (w2k) file size of temp01.ora grows faster... I've setup multimaster replication and as a result got temporary tablespace about 10 Gb. OEM shows that used only about 1Gb, so others 9Gb are gone. I wanna to free them for my purposes. Perhaps you could clarify what you mean by 'it grows up faster and faster'. What exactly does that mean, what script or tool is showing you that, what is its output, and why is it a problem? Restarting the database seems extreme advice for such a meager description of a problem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Clean temporary tablespace
Well, I mean that OS (w2k) file size of temp01.ora grows faster... I've setup multimaster replication and as a result got temporary tablespace about 10 Gb. OEM shows that used only about 1Gb, so others 9Gb are gone. I wanna to free them for my purposes. Perhaps you could clarify what you mean by 'it grows up faster and faster'. What exactly does that mean, what script or tool is showing you that, what is its output, and why is it a problem? Restarting the database seems extreme advice for such a meager description of a problem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Clean temporary tablespace
I have been using this method in all my 8.0 and 8.1 databases. Unfortunately, if it is a TEMPORARY Tablespace with a TEMPFILE, [as I have begun using in 9.2] this command fails. Then, the only option to either resize the TEMPFILE or resize the TEMPORARY Segment is to drop and recreate the TEMPORARY Tablespace as I have outlined in another email. Hemant At 03:54 PM 13-11-03 -0800, you wrote: 8.1.6.3 SQL select status,contents,extent_management,allocation_type from dba_tablespaces where tablespace_name='TEMP'; Extent STATUSCONTENTS Management ALLOCATIO - - -- - ONLINETEMPORARY DICTIONARY USER SQL alter tablespace TEMP default storage(pctincrease 0); Tablespace altered. SQL This will force the SMON to wake up and coalesce those segments which have been used but not freed. This will work if you are using DICT.Managed temp tablespaces. I have been using it regularly with results. HTH GovindanK On Tue, 11 Nov 2003 22:24:24 -0800, VirVit [EMAIL PROTECTED] said: Hello! How can I clean temporary tablespace? It grows up faster and faster. -- ðÏÃÅÌÕÅ× ÷ÉÔÁÌÉÊ éÇÏÒÅ×ÉÞ (VirVit) Oracle 9i DBA beginner -- http://www.fastmail.fm - Sent 0.02 seconds ago -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Clean temporary tablespace
End of the day, read to it through fast, what can I say. I totally blew by the part that said 'TEMPORARY'. Now that I realize which thread I'm in, going back through it reveals that the original poster has still not clarified his original post. eg. there isn't enough information provided to form any conclusions Jared GovindanK [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/13/2003 05:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Clean temporary tablespace Jared Though manual says it, in reality the SMON does not really release the TEMP segments at periodic intervals. I agree with the fact that if pcti 0 then SMON is supposed to coalesce. But the frequency with which it does may not be acceptable when compared to the rate at which the TEMP segment is getting filled. Hence i suggested this. This is mentioned in Metalink too. HTH GovindanK On Thu, 13 Nov 2003 17:19:24 -0800, [EMAIL PROTECTED] said: Actually, you need to set the PCTINCREASE to a non zero value for automatic coalescing to take place. It isn't needed in any case. Oracle will do this automatically, if needed, when an object extends. It's all in the fine concepts manual. Jared GovindanK [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/13/2003 03:54 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L ORACLE- [EMAIL PROTECTED] cc: Subject:Re: Clean temporary tablespace 8.1.6.3 SQL select status,contents,extent_management,allocation_type from dba_tablespaces where tablespace_name='TEMP'; Extent STATUS CONTENTS Management ALLOCATIO - - -- - ONLINE TEMPORARY DICTIONARY USER SQL alter tablespace TEMP default storage(pctincrease 0); Tablespace altered. SQL This will force the SMON to wake up and coalesce those segments which have been used but not freed. This will work if you are using DICT.Managed temp tablespaces. I have been using it regularly with results. HTH GovindanK On Tue, 11 Nov 2003 22:24:24 -0800, VirVit [EMAIL PROTECTED] said: Hello! How can I clean temporary tablespace? It grows up faster and faster. -- pOCELUEW wITALIJ iGOREWI^ (VirVit) Oracle 9i DBA beginner -- http://www.fastmail.fm - The way an email service should be -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Clean temporary tablespace
I got the impression that the poster was thinking segments allocated in temp tablespace must be released, cleaned out, blown away, etc. before something else can come along and use the space. -Original Message- End of the day, read to it through fast, what can I say. I totally blew by the part that said 'TEMPORARY'. Now that I realize which thread I'm in, going back through it reveals that the original poster has still not clarified his original post. eg. there isn't enough information provided to form any conclusions -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Clean temporary tablespace
[EMAIL PROTECTED] scribbled on the wall in glitter crayon: I got the impression that the poster was thinking segments allocated in temp tablespace must be released, cleaned out, blown away, etc. before something else can come along and use the space. i was always under the impression that you didn't need to do anything to the temp tablespace. that the segments were just reused as needed. am i behind the times here? -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Shift to the left! Shift to the right! Pop up, push down, byte, byte, byte! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Clean temporary tablespace
Ja. That was my point ... and probably why some people didn't quite understand the original question (a lot of assumption on my part, but I think that is what the confusion was about). -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 12:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: Clean temporary tablespace [EMAIL PROTECTED] scribbled on the wall in glitter crayon: I got the impression that the poster was thinking segments allocated in temp tablespace must be released, cleaned out, blown away, etc. before something else can come along and use the space. i was always under the impression that you didn't need to do anything to the temp tablespace. that the segments were just reused as needed. am i behind the times here? -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] -- -- Shift to the left! Shift to the right! Pop up, push down, byte, byte, byte! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Clean temporary tablespace
I agree with you Bill. My temp space is always 80% full. I ignore it until I get a report of a sql error. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, November 14, 2003 1:09 PM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] scribbled on the wall in glitter crayon: I got the impression that the poster was thinking segments allocated in temp tablespace must be released, cleaned out, blown away, etc. before something else can come along and use the space. i was always under the impression that you didn't need to do anything to the temp tablespace. that the segments were just reused as needed. am i behind the times here? -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Shift to the left! Shift to the right! Pop up, push down, byte, byte, byte! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Clean temporary tablespace
8.1.6.3 SQL select status,contents,extent_management,allocation_type from dba_tablespaces where tablespace_name='TEMP'; Extent STATUSCONTENTS Management ALLOCATIO - - -- - ONLINETEMPORARY DICTIONARY USER SQL alter tablespace TEMP default storage(pctincrease 0); Tablespace altered. SQL This will force the SMON to wake up and coalesce those segments which have been used but not freed. This will work if you are using DICT.Managed temp tablespaces. I have been using it regularly with results. HTH GovindanK On Tue, 11 Nov 2003 22:24:24 -0800, VirVit [EMAIL PROTECTED] said: Hello! How can I clean temporary tablespace? It grows up faster and faster. -- ðÏÃÅÌÕÅ× ÷ÉÔÁÌÉÊ éÇÏÒÅ×ÉÞ (VirVit) Oracle 9i DBA beginner -- http://www.fastmail.fm - Sent 0.02 seconds ago -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Clean temporary tablespace
Actually, you need to set the PCTINCREASE to a non zero value for automatic coalescing to take place. It isn't needed in any case. Oracle will do this automatically, if needed, when an object extends. It's all in the fine concepts manual. Jared GovindanK [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/13/2003 03:54 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Clean temporary tablespace 8.1.6.3 SQL select status,contents,extent_management,allocation_type from dba_tablespaces where tablespace_name='TEMP'; Extent STATUS CONTENTS Management ALLOCATIO - - -- - ONLINE TEMPORARY DICTIONARY USER SQL alter tablespace TEMP default storage(pctincrease 0); Tablespace altered. SQL This will force the SMON to wake up and coalesce those segments which have been used but not freed. This will work if you are using DICT.Managed temp tablespaces. I have been using it regularly with results. HTH GovindanK On Tue, 11 Nov 2003 22:24:24 -0800, VirVit [EMAIL PROTECTED] said: Hello! How can I clean temporary tablespace? It grows up faster and faster. -- ðÏÃÅÌÕÅ× ÷ÉÔÁÌÉÊ éÇÏÒÅ×ÉÞ (VirVit) Oracle 9i DBA beginner -- http://www.fastmail.fm - Sent 0.02 seconds ago -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Clean temporary tablespace
Jared Though manual says it, in reality the SMON does not really release the TEMP segments at periodic intervals. I agree with the fact that if pcti 0 then SMON is supposed to coalesce. But the frequency with which it does may not be acceptable when compared to the rate at which the TEMP segment is getting filled. Hence i suggested this. This is mentioned in Metalink too. HTH GovindanK On Thu, 13 Nov 2003 17:19:24 -0800, [EMAIL PROTECTED] said: Actually, you need to set the PCTINCREASE to a non zero value for automatic coalescing to take place. It isn't needed in any case. Oracle will do this automatically, if needed, when an object extends. It's all in the fine concepts manual. Jared GovindanK [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/13/2003 03:54 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L ORACLE- [EMAIL PROTECTED] cc: Subject:Re: Clean temporary tablespace 8.1.6.3 SQL select status,contents,extent_management,allocation_type from dba_tablespaces where tablespace_name='TEMP'; Extent STATUSCONTENTS Management ALLOCATIO - - -- - ONLINETEMPORARY DICTIONARY USER SQL alter tablespace TEMP default storage(pctincrease 0); Tablespace altered. SQL This will force the SMON to wake up and coalesce those segments which have been used but not freed. This will work if you are using DICT.Managed temp tablespaces. I have been using it regularly with results. HTH GovindanK On Tue, 11 Nov 2003 22:24:24 -0800, VirVit [EMAIL PROTECTED] said: Hello! How can I clean temporary tablespace? It grows up faster and faster. -- pOCELUEW wITALIJ iGOREWI^ (VirVit) Oracle 9i DBA beginner -- http://www.fastmail.fm - The way an email service should be -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Clean temporary tablespace
Hi, Restartup your database if possible. If you set the datafile autoextent on then you have to recreate that tablespace, if you set it to not autoextent on for some query may fail due to not enough sorting space. Sinardy -Original Message- Sent: 12 November 2003 14:24 To: Multiple recipients of list ORACLE-L Hello! How can I clean temporary tablespace? It grows up faster and faster. -- (VirVit) Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Clean temporary tablespace
Or you can 1. Create another Temporary Tablespace with CREATE TEMPORARY TABLESPACE new_temporary_tablespace TEMPFILE . SIZE ... AUTOEXTEND ON NEXT .. MAXSIZE ... 2. Issue ALTER USER TEMPORARY TABLESPACE new_temporary_tablespace commands 3. If running 9.2 with a Default Temporary Tablespace, ALTER DATABASE DEFAULT TEMPORARY TABLESPACE new_temporary_tablespace 4. Check that there are no active sessions still using the existing Temporary Tablespace, querying V$SORT_SEGMENT and also use the Unix fuser command against the Temporary Tablespace Tempfiles 5. DROP TABLESPACE current_temporary_tablespace INCLUDING CONTENTS [add AND DATAFILES if using 9.2] Note : Ensure that you really have no segments in the tablespace other than the temporary segment [ie, it is really a temporary tablespace ! because the DROP TABLESPACE command syntax doesn't specify if it is a TEMPORARY or PERMANENT tablespace] 6. Recreate your original Temporary Tablespace 7. Run through Steps 2 and 3 again to revert to the original Temporary Tablespace 8. Run Steps 4 and 5 to drop the new_temporary_tablespace Because, bouncing or restarting the Database Instance isn't always an available option! Hemant At 12:05 AM 12-11-03 -0800, you wrote: Hi, Restartup your database if possible. If you set the datafile autoextent on then you have to recreate that tablespace, if you set it to not autoextent on for some query may fail due to not enough sorting space. Sinardy -Original Message- Sent: 12 November 2003 14:24 To: Multiple recipients of list ORACLE-L Hello! How can I clean temporary tablespace? It grows up faster and faster. -- ðÏÃÅÌÕÅ× ÷ÉÔÁÌÉÊ éÇÏÒÅ×ÉÞ (VirVit) Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Clean temporary tablespace
Perhaps you could clarify what you mean by 'it grows up faster and faster'. What exactly does that mean, what script or tool is showing you that, what is its output, and why is it a problem? Restarting the database seems extreme advice for such a meager description of a problem. Jared On Tue, 2003-11-11 at 22:24, VirVit wrote: Hello! How can I clean temporary tablespace? It grows up faster and faster. -- (VirVit) Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Clean temporary tablespace
Hello! How can I clean temporary tablespace? It grows up faster and faster. -- (VirVit) Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).