Drop tablespace - slow
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Drop tablespace - slow

  1. #1
    Join Date
    Apr 2002
    Posts
    50
    I am using Oracle 8.1.7 on Solaris. My TEMP tablespace is of size 3GB and I want to maintain it at 1GB. The HWM is at 2.6G, so I created a new temporary tablespace, assigned it to all the users who were using the old one, brought the old one offline and ran the
    DROP TABLESPACE TEMP INCLUDING CONTENTS;

    The database is live and this process is really slow - it has been running for 2 hours now - as I have renamed the default temp tablespace for all the users I know this tablespace is not being used. Is this time period normal ? If not, what am I doing wrong ? The old temp tablespace was database managed.

    Thanks,
    Shiva.

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    There may be extents created in the "old" temp tablespace that are yet to be freed (dropped). Query from DBA_EXTENTS to check any extent is present for that tablespace.

  3. #3
    Join Date
    Apr 2002
    Posts
    50
    I do have lot of extents for this tablespace - around 11944 in number. That may be the reason why it is taking this much time and this number is decreasing slowly.
    But I checked the entries in sys.fet$ and they seem to be increasing by the time. Does this mean that the tablespace is being used by someone ?

    Thanks,
    Shiva.

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    fet$ means free extents you know?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width