Turning on autotrace permanently
963814Dec 18 2012 — edited Dec 19 2012I 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?