Please send your Questions & Answers or Feedback to ""

Please send your Questions & Answers or Feedback to ""

Query to identify long running queries

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;

Related Posts Plugin for WordPress, Blogger...

Flag Counter