ODAC 6.10 alter session ?
Posted: Wed 18 Jul 2007 15:21
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.
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.