Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to tell if a session has sql_trace set for 12c?

User_XYoci6Jul 7 2022

sql_trace in v$session is deprecated for 12c, as this shows:

SQL> select sys_context('USERENV','SID') from dual;
1348
SQL> alter session set sql_trace=true;
Session altered.
SQL> select sql_trace, sid from v$session where sid = 1348;
DISABLED 1348
So, how do you determine which session has sql_trace set?

Added on Jul 7 2022

#database-key-features, #replication

0 comments

161 views