Stats pack is a performance tuning tool. It is used when you want to tune your database. So you would run the statspack on a regular interval and gather statistics on your database and then you would use it's report to find out the cholk points and bottle necks and start tuning in one by one.

Sam