Skip to content

Instantly share code, notes, and snippets.

@Tracnac

Tracnac/Extraction des requêtes couteuses.md

Last active September 23, 2022 16:36
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Tracnac/3ff7e9e7a826c2017b001b472fd0fe3e to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Tracnac/3ff7e9e7a826c2017b001b472fd0fe3e to your computer and use it in GitHub Desktop.
Download ZIP
Extraction des requêtes couteuses #oracle #performance
Raw
Extraction des requêtes couteuses.md 
select dhsnap.begin_interval_time, dhsnap.end_interval_time, dhstat.cpu_time_total/1000000 time_exec_seconds, dhstat.sql_id, replace(to_char(substr(dhsql.sql_text,1,128)),chr(10),'') sql_text
from DBA_HIST_SQLSTAT dhstat, DBA_HIST_SNAPSHOT dhsnap, DBA_HIST_SQLTEXT dhsql
where dhstat.parsing_schema_name = '<SHEMANAME>'
and dhstat.snap_id = dhsnap.snap_id
and dhstat.sql_id = dhsql.sql_id
order by time_exec_seconds desc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment