Description:
This Document for configuring oracle Statspack, schedule auto snapshot and report generation. The Statspack tool is instead of AWR report because AWR is licensed Statspack is non licensed.
Steps:
- Create a tablespace for Statspack (tablespace name: Statspack)
- Locate and run the Statspack create script (this is installing Statspack and automatically creating user called “PERFSTAT” and creating tables & synonyms.)
SQL>$ORACLE_HOME/rdbms/admin/spcreate.sql
- check and connect with the perfstat user
conn perfstat/<password>
- once completed installation execute manual snap.
EXEC STATSPACK.snap;
- Configure automatic snap (this is collecting snapshot for every hour)
$ORACLE_HOME/rdbms/admin/spauto.sql
- Run the spreport.sh (parameter: start snap id, end snap id, report file name)
$ORACLE_HOME/rdbms/admin/spreport.sql
Notes:
If you delete the snapshot collections.
$ORACLE_HOME/rdbms/admin/sppurge.sql
Reference:
ORACLE-BASE/Statspack document.
Recent Posts
