Could someone please confirm is this the way to check if we have license to generate AWR report in the database?
SQL> show parameter control_management_pack_access;
SQL>
When I try to generate statspack on the database I get following errors. Looks statspack is not installed. Could someone please confirm?
SQL> @?/rdbms/admin/spreport
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
1387237475 ADM 1 adm
Instances in this Statspack schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
from stats$database_instance
*
ERROR at line 7:
ORA-00942: table or view does not exist
Using 1387237475 for database Id
Using 1 for instance number
from stats$database_instance
*
ERROR at line 5:
ORA-06550: line 5, column 13:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 4, column 6:
PL/SQL: SQL Statement ignored
ORA-06550: line 11, column 13:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 10, column 6:
PL/SQL: SQL Statement ignored