How To Create Statspack Report

STATSPACK RUNNING PROCEDURE

Conn As Perfstat User
As
exec statspack.snap

Again Execute Statspack’s Snap Prodedure After Some Time (e.g 1 hour or 2 hours Whenever There Is So Much Transactions Are RunningASexec statspack.snap
　

NOTE: Here We Execute Statspack Procedure Two Times Which Will Create Two Point Of Time Images of Database .In Which We Are Going To Run Statspack Report For Finding out The Database Picture .

　
Now Run Statspack ReportAs@?/rdbms/admin/spreport
and then press ENTER
This Will Create SPREPORT