Oracle DBA and beyond; these are practical tips for day to day DBA operation and maintenance; a place where you would come to look for a quick fix for a burning situation. I hope that by sharing all these, we all will become better in what we do. And on the way, I hope to save you some sweat :-)
Sunday, 8 February 2015
How to trace a specific query, using its SQL_ID?
The answer is to use "set events":
alter system set events 'sql_trace[sql:gb07958tf8xdk] bind=true,wait=false';
A few more detailed examples at:
http://oraclue.com/2009/03/24/oracle-event-sql_trace-in-11g/
No comments:
Post a Comment