ALTER_SCHEMA_TABLE_MONITORING Procedure

This procedure enable or disables the DML monitoring feature of all the tables in the schema, except for snapshot logs and the tables, which monitoring does not support. Equivalent to issuing ALTER TABLE ... MONITORING (or NOMONITORING) individually. It is recommended to enable monitoring if you use gather_database_stats or gather_schema_stats with GATHER AUTO or GATHER STALE option.

Syntax

DBMS_STATS.alter_schema_table_monitoring (

ownname varchar2 default NULL,
monitoring boolean default TRUE);

Parameters

Table 63-40 ALTER_SCHEMA_TABLE_MONITORING Procedure Parameters

Parameter	Description
ownname	The name of the schema. (NULL means the current schema.)
monitoring	Enables monitoring if true, and disables monitoring if false.

Exceptions

ORA-20000: Insufficient privileges.