tracing session using dbms package
Hello: I am trying to trace a particular session and get this message
SQL> execute dbms_system.set_sql_trace_in_session (41, 721, TRUE);
BEGIN dbms_system.set_sql_trace_in_session (41, 721, TRUE); END;
*
ERROR at line 1:
ORA-06509: PL/SQL: ICD vector missing for this package
ORA-06512: at "COTPROD.DBMS_SYSTEM", line 54
ORA-06512: at "COTPROD.DBMS_SYSTEM", line 46
ORA-06512: at line 1
How do I resolve this issue? If I have to run catproc or catlog.sql on a production system, is it OK? and how would I do that without any problems. Should users be on or off and any risks?
Thanks, ST2000