Page 1 of 1

ODAC 6.10 alter session ?

Posted: Wed 18 Jul 2007 15:21
by wchris
Hello,

DBmonitor shows that ODAC 6.10 launches the following alter session command after connecting to the database.

ALTER SESSION SET statistics_level = TYPICAL

ALTER SESSION SET timed_statistics = TRUE ;

ALTER SESSION SET EVENTS '10046 trace name context forever, level 1' ;

Can you explain why ? (we don't use statistics our queries are rule based)
perhaps an option can disable this ? The trace command is for debugging purpose ?

the first ALTER SESSION SET statistics_level = TYPICAL fails on oracle release 900010101 with the message ORA-02248.

Connecting to the database is still possible, but the error message raises.

Posted: Thu 19 Jul 2007 08:37
by Plash
These statements are executed if you use the TOraTrace component in your application. You should find this component in your application and delete it, or set the Enabled property of the component to False.

Posted: Thu 19 Jul 2007 08:56
by wchris
Plash wrote:These statements are executed if you use the TOraTrace component in your application. You should find this component in your application and delete it, or set the Enabled property of the component to False.
Thank you, you where right, someone dropped a TOratrace component on a form.

After removing TOratrace everything is working well again.

Thank you very much.