Oracle9i - Check Progress Of Expimp
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Oracle9i - Check Progress Of Expimp as PDF for free.
More details
- Words: 77
- Pages: 1
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_min
FROM
sys.v_$sqlarea
WHERE
sql_text like 'INSERT %INTO "ZDUND%' and
command_type = 2 and
open_versions > 0;
OUPUT>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 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_min from sys.v_$sqlarea where sql_text like 'INSERT %INTO "ZACTHIS%' and command_type = 2 and open_versions > 0; 2 3 4 5 6 7 8 TABLE_NAME ROWS_PROCESSED MINUTES ROWS_PER_MIN ------------------------------ -------------- ---------- -----------INTO "ZACTHIS" ("CLIENT", "NRD 83073900 1436.1 57848
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_min
FROM
sys.v_$sqlarea
WHERE
sql_text like 'INSERT %INTO "ZDUND%' and
command_type = 2 and
open_versions > 0;
OUPUT>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 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_min from sys.v_$sqlarea where sql_text like 'INSERT %INTO "ZACTHIS%' and command_type = 2 and open_versions > 0; 2 3 4 5 6 7 8 TABLE_NAME ROWS_PROCESSED MINUTES ROWS_PER_MIN ------------------------------ -------------- ---------- -----------INTO "ZACTHIS" ("CLIENT", "NRD 83073900 1436.1 57848
Related Documents
Oracle9i - Check Progress Of Expimp
November 2019 7
Oracle9i - Transfer Data Between Database Via Expimp
November 2019 9
Check Progress ( Unit 1)
June 2020 8
Progress Check Ps Pc.docx
June 2020 6
Installation Of Oracle9i
November 2019 4