Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_STATS, 40 of 41
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.
DBMS_STATS.alter_schema_table_monitoring (ownname varchar2 default NULL, monitoring boolean default TRUE);
Parameter | Description |
---|---|
|
The name of the schema. ( |
|
Enables monitoring if true, and disables monitoring if false. |
ORA-20000: Insufficient privileges.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|