Skip to Main Content

SQL & PL/SQL

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!

Turning on autotrace permanently

963814Dec 18 2012 — edited Dec 19 2012
I just found out about autotrace and decided to use it for some queries I'm running from a Java program. So I've tried opening up SQL Developer and then a SQL window, and typed in set autotrace on. After that, any statements I write come up with lots of statistics as expected. But if I open up a new window to the same connection, autotrace is not enabled in that, and if I close down the first window, autotrace is off again. So isn't there a way to permanently set autotrace on for a database, rather than having to do it for each new window I open in SQL Developer?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 16 2013
Added on Dec 18 2012
7 comments
686 views