sys>select username,target,sofar blocks_read,totalwork total_blocks,round(time_remaining/60)minutes from v$session_longops where sofar <> totalwork and username='SCOTT';
scott>delete from emp where empno=7902;
emp contains 10 million records.
sys>select table_name,round(blocks*8),2/1024 as total,round(num_rows*avg_row_len/1024),2)/1024 as
original,round(blocks*8),2)/1024-round(num_rows*avg_row_len/1024),2)1024 as free from dba_tables where owner='SCOTT';
sys>alter table scott.emp shrink space cascade;
scott>desc user_recyclebin
scott>select object_name,original_name,droptime from user_recyclebin;
