sppurge deletes SP data but Tablespace still full
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: sppurge deletes SP data but Tablespace still full

  1. #1
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510

    sppurge deletes SP data but Tablespace still full

    (9.2)
    I ran the $ORACLE_HOME/rdbms/admin/sppurge for more than 95% of the data stored in the STATSPACK tables. The used space in the associated tablespace did not go down at all. STATSPACK is the only tool code using this tablespace.

    How do I free up the space in the tablespace? It is LMT.

  2. #2
    Join Date
    Dec 2002
    Location
    Munich, Germany
    Posts
    20
    If you take a look into sppurge.sql script you can see that "delete" command used. Therefore hwm does't move and storage still allocated. If you really want to deallocate storage - use sptrunc.sql instead. But that will drop 100% statistics data.

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