Иногда интересно без трассировки посмотреть использованные запросом ресурсы и ожидания
Сделать это можно следующим образом
SQL код:
select snap_id as ID,
sql_id as SQL,
optimizer_cost as COST,
sorts_total as SORTS,
executions_total as EXE,
parse_calls_total as PARSES,
disk_reads_total as DISK_READS,
buffer_gets_total as BUFFERS,
rows_processed_total as ROWS_,
cpu_time_total as CPU_TIME,
iowait_total as IOWAITS,
apwait_total as APWAITS,
ccwait_total as CCWAITS
from dba_hist_sqlstat
where sql_id = 'ID ЗАПРОСА'
order by 1 desc