Oracle import process hanged !! how to handle

Hi

Some times, i use to do a dev refreshes without checking the pre- requisites like size , object counts etc .. but i will pay my time for the same when i see the import taking long time than i expected.

so the below query can be used to see what actually the import process is currently doing inside the db , like which table is getting loaded how many rows are getting updated till  now and we can calculate how long the processs could take etc .. it is a use full quey which i frequently use


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 "%'
and command_type = 2
and open_versions > 0;


and basically check if the imp process still exist on the server

ps -ef | grep imp

oracle user password expired locked

In 11 r2 , were facing this user lock and expire issue frequently to override it


select profile from dba_users where username ='xxxx';

alter profile default limit passsword_life_time unlimited;
alter profile default limit failed_login_attempts unlimited;

select resource_name,limit from dba_profiles where profile='';