ALTER_DATABASE_TABLE_MONITORING Procedure

This procedure enables or diables 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 the GATHER AUTO or GATHER STALE options.

Syntax

DBMS_STATS.ALTER_DATABASE_TABLE_MONITORING (

monitoring boolean default TRUE,
sysobjs boolean default FALSE);

Parameters

Table 63-41

Parameter	Description
monitoring	Enables monitoring if true, and disables monitoring if false.
sysobjs	If true, changes monitoring on the dictionary objects.

Exzceptions

ORA-20000: Insufficient privileges.