Find the problematic SQL ID to investigate, then execute: col report_id new_v report_id select * from ( select * from DBA_HIST_REPORTS where key1 = '&&sql_id' and COMPONENT_NAME = 'sqlmonitor' order by generation_time desc ) where rownum = 1; This will give you the most recent execution, but you may want to use different criteria. Next, …
Using DBMS_AUTO_REPORT to retroactively identify performance problems weiterlesen
Du muss angemeldet sein, um einen Kommentar zu veröffentlichen.