Can anyone tell me how to clear the statspack reports that are saved on the DB??
how many reports can the DB hold??
Printable View
Can anyone tell me how to clear the statspack reports that are saved on the DB??
how many reports can the DB hold??
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)
or use sptrunc.sql to truncate the schema tables
thank you people, greatly appreciated.