dbms_stats.alter_database_table_monitoring
Greetings,
I am having trouble with the dbms_stats package while trying to implement automated statistics in 9i.
This article is Gathering Optimzer Statistics
http://download.oracle.com/docs/cd/B10501_01/server.920/a96533/stats.htm#33861
This article is DBMS_Stats subprograms
http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_stats2.htm#1012921
First I try to enable monitoring of the tables for the whole database:
SQL> execute dbms_stats.alter_database_table_monitoring();
BEGIN dbms_stats.alter_database_table_monitoring(); END;
*
ERROR at line 1:
ORA-06550: line 1, column 18:
PLS-00114: identifier 'ALTER_DATABASE_TABLE_MONITORIN' too long
Then I try at the schema level:
SQL> execute dbms_stats.alter_schema_table_monitoring('MYSCHEMA');
BEGIN dbms_stats.alter_schema_table_monitoring('MYSCHEMA'); END;
*
ERROR at line 1:
ORA-06550: line 1, column 18:
PLS-00302: component 'ALTER_SCHEMA_TABLE_MONITORING' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Any suggestions on what I am doing wrong?
Henry