DBA Hub

📋Steps in this guide1/1

execution detail of a sql_id in cursor

select module,parsing_schema_name,inst_id,sql_id,plan_hash_value,child_number,sql_fulltext, to_char(last_active_time,'DD/MM/YY HH24:MI:SS' ),sql_plan_baseline,executions, elapsed_time/executions/1000/1000,rows_processed from gv$sql where sql_id in ('&sql_id');

oracle configurationintermediate
by OracleDba
11 views
1

execution detail of a sql_id in cursor

Code/Command (click line numbers to comment):

1
2
3
4
select module,parsing_schema_name,inst_id,sql_id,plan_hash_value,child_number,sql_fulltext,
to_char(last_active_time,'DD/MM/YY HH24:MI:SS' ),sql_plan_baseline,executions,
elapsed_time/executions/1000/1000,rows_processed from gv$sql
where sql_id in ('&sql_id');

Comments (0)

Please to add comments

No comments yet. Be the first to comment!