# lsof /opt/app/oracle/oradata/orcl/temp*.dbf|perl -lane '$.>1 and print $F[1]'|sort -u|xargs ps u -p USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND oracle 14055 0.6 22.0 2310344 682440 ? Ds 16:39 1:32 oracleorcl (LOCAL=NO) oracle 15368 0.3 17.5 2279768 542228 ? Ss Jun01 36:38 ora_dbw0_orcl oracle 15370 0.1 0.9 2269800 27896 ? Ss Jun01 18:29 ora_lgwr_orcl oracle 15374 0.0 4.1 2248704 128732 ? Ss Jun01 1:14 ora_smon_orcl oracle 15380 0.0 1.8 2248820 58552 ? Ss Jun01 0:46 ora_mmon_orcl