how do i clear statspack reports

[Linux_cat]

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

how many reports can the DB hold??

[davey23uk]

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)

[robertbalmer]

or use sptrunc.sql to truncate the schema tables

[Linux_cat]

thank you people, greatly appreciated.