# Turn tracing on (it's off by default): SET optimizer_trace="enabled=on"; SELECT ...; # your query here SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE; # possibly more queries... # When done with tracing, disable it: SET optimizer_trace="enabled=off";
A session can trace only statements which it executes; it cannot see a trace of another session.
Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices