Oracle Database Discussions

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