Martin Klier


Oracle 11g trace particular SQL_ID

As a follow-up of my last post, I learned that creating traces is much simpler in 11g than I expected it to be. Dion Cho and Tanel Poder pointed me to some interesting links http://oraclue.com/2009/03/24/oracle-event-sql_trace-in-11g/ http://tech.e2sn.com/oracle/troubleshooting/oradebug-doc describing how to set up a trace event on one SQL_ID without need to do it on session level […]

read more

Oracle: Tracing of another session

I simply love 10046 level 12 traces. I described session tracing based on a logon trigger quite earlier, but some situations in real DBA life need this trace event switched on for a session other than my own AND for a short peroid in time (with no need for the connected user to log out). […]

read more