DBA Tips Archive for Oracle
Monitor Import Speed
by Don Burleson <www.dba-oracle.com>
One of the more perplexing issues for an Oracle administrator is tracking the execution of an Oracle import. When a production system is down, IT managers are anxious to know the progress of the Oracle Import utility. For very large tables, the Oracle Import utility can take many hours, and the DBA needs to know the rate at which the utility is adding rows to the table. To monitor how fast rows are imported from a running import job, try the following method.
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 FROM sys.v_$sqlarea WHERE sql_text like 'INSERT %INTO "%' AND command_type = 2 AND open_versions > 0;Don Burleson, one of the world's top Oracle database experts, has written 12 books, has published more than 70 articles in national magazines, and serves as editor in chief of Oracle Internals, a leading Oracle database journal. As a leading corporate database consultant, Don has worked with numerous Fortune 500 corporations creating robust database architectop of IT trendstures for mission-critical systems
Copyright (c) 1998-2018 Jeffrey M. Hunter. All rights reserved.
All articles, scripts and material located at the Internet address of http://www.idevelopment.info is the copyright of Jeffrey M. Hunter and is protected under copyright laws of the United States. This document may not be hosted on any other site without my express, prior, written permission. Application to host any of the material elsewhere can be made by contacting me at firstname.lastname@example.org.
I have made every effort and taken great care in making sure that the material included on my web site is technically accurate, but I disclaim any and all responsibility for any loss, damage or destruction of data or any other property which may arise from relying on it. I will in no case be liable for any monetary damages arising from such loss, damage or destruction.