Newsgroups: comp.databases.oracle.server Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.glorb.com!sws1!ornl!news.er.usgs.gov!news From: Brian Peasland Subject: Re: drop temp tablespace takes forever In-Reply-To: <26d66$45363723$5277c1be$5875@news0.easynet.it> X-Nntp-Posting-Host: edc-cv-160-59.cr.usgs.gov Content-Type: text/plain; charset=ISO-8859-1; format=flowed Message-ID: User-Agent: Thunderbird 1.5.0.7 (Windows/20060909) Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739) Content-Transfer-Encoding: 7bit Organization: U.S. Geological Survey, Reston VA References: <26d66$45363723$5277c1be$5875@news0.easynet.it> Mime-Version: 1.0 Date: Wed, 18 Oct 2006 14:59:53 GMT Lines: 60 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:277614 maxim2k wrote: > Hi, > > I'm running Oracle Database 10g R2 on Red Hat Enterprise Linux 4. > > For some reason the temp01.dbf file has grown to 32GB lately! > > So in order to bring it down, I tried to follow the directions in the > following article: > > > > > Here is the suggested process: > > - create a new support temporary tablespace and make it the default for > the database > > - drop the original TEMP tablespace > > - recreate a new TEMP tablespace, make it the default and drop the > support tablespace > > But I'm stuck at the dropping the original TEMP tablespace with the > followinf command: > > DROP TABLESPACE TEMP INCLUDING CONTENTS AND DATAFILES; > > The above command has been running for an hour or so on my server and > didn't finish yet. > > Is it supposed to be so slow? > > How can I check its progress? > > If I need to, how do I kill it without corrupting the database? > > Thanks. If users are actively using the tablespace, the DROP command will wait for those sessions to release their locks on that tablespace. How long this takes depends on the session's activity. HTH, Brian -- =================================================================== Brian Peasland dba@nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - Unknown