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

Thread: how do i clear statspack reports

  1. #1
    Join Date
    Oct 2005
    Posts
    26

    how do i clear statspack reports

    Can anyone tell me how to clear the statspack reports that are saved on the DB??

    how many reports can the DB hold??

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    it can hold as many as it wants to (until it runs out of space)

    but use sppurge to delete reports (it uses a low snap id and a high snap id to find the range to delete)

  3. #3
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    or use sptrunc.sql to truncate the schema tables
    Able was I ere I saw Elba

  4. #4
    Join Date
    Oct 2005
    Posts
    26
    thank you people, greatly appreciated.

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