📋Steps in this guide1/1

Top Query with high elapsed time

Queries in last 1 hour ( Run from Toad, for proper view)

oracle configurationintermediate

by OracleDba

11 views

Top Query with high elapsed time

Queries in last 1 hour ( Run from Toad, for proper view)

Code/Command (click line numbers to comment):

Select module,parsing_schema_name,inst_id,sql_id,CHILD_NUMBER,sql_plan_baseline,sql_profile,plan_hash_value,sql_fulltext,
to_char(last_active_time,'DD/MM/YY HH24:MI:SS' ),executions, elapsed_time/executions/1000/1000,
rows_processed,sql_plan_baseline from gv$sql where last_active_time>sysdate-1/24
and executions <> 0 order by elapsed_time/executions desc

Comments (0)

Please to add comments

No comments yet. Be the first to comment!