activate the monitoring attribute for table

[Former Member]

HI All,

Issue is need to activate the monitoring attribute for table.....

I tried through sql...as below

SQL> select table_name from sys.dba_tables where table_name

like '%BIC/EYFSFCONS%';

TABLE_NAME

-

---

/BIC/EYFSFCONS

SQL> select owner from sys.dba_tables where table_name

like '%BIC/EYFSFCONS%';

2

OWNER

-

---

SAPDAT

SQL> alter table SAPDAT. "BIC/EYFSFCONS" monitoring;

alter table SAPDAT. "BIC/EYFSFCONS" monitoring

*

ERROR at line 1:

ORA-00942: table or view does not exist

could u please help in how to resolve the issue.

Thanks in advances

[stefan_koehler]

Hello Sonu,

what oracle version are you using? (the monitoring attribute has changed until 10g)

I think you forget one "/" in the table name:

>SQL> alter table SAPDAT. "BIC/EYFSFCONS" monitoring;

>alter table SAPDAT. "BIC/EYFSFCONS" monitoring

>*

>ERROR at line 1:

>ORA-00942: table or view does not exist

Try this:

> SQL> alter table SAPDAT."/BIC/EYFSFCONS" monitoring;

But be aware the monitoring attribute is not needed anymore in Oracle 10g - it is controlled by the parameter STATISTICS_LEVEL :

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams211.htm#CHDDAHJD

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/tables.htm#sthref2270

> Starting with Oracle Database 10g, the MONITORING and NOMONITORING keywords have been deprecated and statistics are collected automatically. If you do specify these keywords, they are ignored.

> To disable monitoring of a table, set the STATISTICS_LEVEL initialization parameter to BASIC. Its default is TYPICAL, which enables automatic statistics collection

Regards

Stefan

[Former Member]

Thanks for reply

issue was solved.