Statspack alternative for performance monitoring Oracle XE because AWR is not licenced

1. Introduction

Unfortunatly, Oracle Express does not license "AWR - Automatic Workload Management" (see references). But performance issues  exists in any system! You can install and use an old Oracle tool called StatsPac to monitor and capture statistical data from your Oracle instance.

2. Step by Step

2.1. Install StatsPack Binary

2.2. Test StatsPack

3. References

• http://www.oracle.com/us/products/database/enterprise-edition/comparisons/index.html
• http://www.oracledistilled.com/oracle-database/performance/installing-and-configuring-statspack/
• http://docs.oracle.com/cd/B10501_01/server.920/a96533/statspac.htm
• http://www.dba-oracle.com/tips_install_oracle_statspack.htm