Oracle11gR2を使っています。
STATSPACK�@�ݒ�菇
Statspackのインストールを試そうとしたのですが、以下のようにエラーとなりました。
どこが間違っていそうでしょうか？
SQL> @"C:\app\XXX\product\11.1.0\db_1\RDBMS\ADMIN\sprepsql.sql"
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
1159374066 XXXX 1 XXXX
Instances in this Statspack schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
from stats$database_instance
*
ERROR at line 7:
ORA-00942: table or view does not exist
Using 1159374066 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
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Pr
oduction
With the Partitioning, OLAP, Data Mining and Real Application Testing options