[ORA 11GR2 12C] Initial Statspack

If you don’t have a license to use the AWR, ADDM, and ASH reports, the free Statspack utility can help you identify poorly performing SQL statements. Run the following script as SYS to install Statspack: 

SQL> @?/rdbms/admin/spcreate.sql
SQL> @ ?/rdbms/admin/spauto.sql  

SQL> @?/rdbms/admin/spreport.sql