UNIX: to Find Files Open After Being Deleted

 cd to the concerned directory:


>lsof | grep -i deleted | sort -r -s -n -k 7


OR


> lsof | grep undotbs | grep delete


The only way to regain the space back is to kill the processes that are running. The PID of the process is field 2.


For example:

oracle-psfsdb602.tmw.com::/rd320/oradata/fsprod/undo01>lsof | grep -i deleted | sort -r -s -n -k 7

oracle_12   12029                           oracle  272u      REG              253,6 33579606016   67108995 /rd320/oradata/fsprod/undo01/undotbs01.dbf (deleted)

oracle_12   12033                           oracle  268u      REG              253,6 33579606016   67108995 /rd320/oradata/fsprod/undo01/undotbs01.dbf (deleted)

oracle_12   12069                           oracle  256u      REG              253,6 33579606016   67108995 /rd320/oradata/fsprod/undo01/undotbs01.dbf (deleted)

oracle_56   56598                           oracle  256u      REG              253,6 33579606016   67108995 /rd320/oradata/fsprod/undo01/undotbs01.dbf (deleted)

oracle_91   91831                           oracle  256u      REG              253,6 33579606016   67108995 /rd320/oradata/fsprod/undo01/undotbs01.dbf (deleted)

oracle_37  372011                           oracle  257u      REG              253,6 33579606016   67108995 /rd320/oradata/fsprod/undo01/undotbs01.dbf (deleted)


Comments

Post a Comment

Popular posts from this blog

Oracle: To clean up WRI$_ADV_OBJECTS

 set linesize 200; select segment_name, segment_type, bytes from dba_segments where tablespace_name='SYSAUX' order by bytes asc; COL OCCUPANT_NAME FORMAT A30 SELECT OCCUPANT_NAME,SPACE_USAGE_KBYTES FROM V$SYSAUX_OCCUPANTS ORDER BY SPACE_USAGE_KBYTES DESC; COL SEGMENT_NAME FORMAT A30 COL OWNER FORMAT A10 COL TABLESPACE_NAME FORMAT A10 COL SEGMENT_TYPE FORMAT A15 SELECT * FROM (SELECT SEGMENT_NAME,OWNER,TABLESPACE_NAME,BYTES/1024/1024 "SIZE(MB)",SEGMENT_TYPE FROM DBA_SEGMENTS WHERE TABLESPACE_NAME='SYSAUX' ORDER BY BYTES DESC) WHERE ROWNUM<=10; 1.  automatic clean-up default 31 days           SELECT dbms_stats.get_stats_history_availability from Dual; 2. modify retention policy        exec  dbms_stats.alter_stats_history_retention (14); 3. a manual cleaning  exec dbms_stats.purge_stats (sysdate-14);   ALTER TABLE WRI$_ADV_OBJECTS MOVE; ALTER INDEX WRI$_ADV_OBJECTS_IDX_01 REBUILD; ALTER INDEX WRI$_ADV_OBJECTS_IDX_02 R...
Read more