Calculate DUMP import time

Question

Calculate DUMP import time

Navigation

#1 by (2 votes)

5

I would like to know, if possible, how to calculate approximate the import time of a Dump .

It could be something considering the following items:

DUMP size in GB.
Tables Amount.
Number of records and (or) rows / columns per table.
Number of Objects, such as Triggers, Functions, Procedures, etc.
Any way to calculate the computing efficiency of computer processing?

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit
NOARCHIVELOG

The computer I use to perform IMPs:

Windows 7 Professional 64bits
  4gb RAM
  i3 3.3GHz

NOTE: Using the command IMP and / or IMPDB .

oracle oracle11c

asked by anonymous 27.01.2016 / 14:31

1 answer

Char pointer or char array? How to manage a project with several variations?

score 2 · Accepted Answer

It is possible to monitor the time using this query:

col table_name format a30

select substr(sql_text, instr(sql_text,'"')+1, 
               instr(sql_text,'"', 1, 2)-instr(sql_text,'"')-1) 
          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 
   v$sqlarea 
where 
  upper(sql_text) like 'INSERT % INTO "%' 
  and 
  command_type = 2 
  and 
  open_versions > 0;
select 
   sid, 
   serial#
from 
   v$session s, 
   dba_datapump_sessions d
where 
   s.saddr = d.saddr;

select 
   sid, 
   serial#, 
   sofar, 
   totalwork
from 
   v$session_longops;

Sources: Here and here