How to Check SQL Execution Time in Oracle Database? DBA scripts to Check SQL Execution Time in Oracle Database?
Amen Answered question 19/04/2023
The sample DBA scripts for SQL Execution Time in Oracle Database:
1 2 3 4 | SQL > select substr(sql_text,instr(sql_text,'INTO "'),30) table_name, rows_processed,round((sysdate-to_date(first_load_time,'yyyy-mm-dd hh24:mi:ss'))*24*60,1)minutes,trunc(rows_processed/((sysdate-to_date(first_load_time,'yyyy-mm-dd hh24:mi:ss'))*24*60)) rows_per_minute fromsys.v_$sqlarea where sql_text like '%&sql_text%' and command_type = 2 and open_versions > 0; |
Amen Answered question 19/04/2023