October 27, 2010 Leave a comment
Not for the first time, I’ve gone looking for more detail on this extended functionality in 11g.
And not for the first time, I’ve started off looking for dbms_monitor extended functionality and not found it and then wasted time trying to remember what I’m looking for:
Note to self – what I’m looking for is not dbms_monitor but simply:
alter session|system set events 'sql_trace[SQL:<sql_id>]...';