Trace only one query

alter session set events ‘sql_trace[sql:9pzmsyh5t14bb]’;

Ref : http://alexanderanokhin.wordpress.com/2012/12/24/timing-query-execution-statistics-rowsource-statistics-part-1-how-it-works/

Advertisements