Tuesday 12 July 2016

Welcome to My DBA Site.....
Hi Everyone!!!!
If i have posted Anything wrong, please give your comments and best answer if anything i missed or written wrong.So I can modify it. Thanks for your TimE.
Posted by at
Labels:

1 comment:

  1. MKumar075 December 2016 at 18:43

    To get hig water mark :

    select file_name, BYTES/(1024*1024) "Size in MB", hwm, blocks total_blocks, ((blocks-hwm+1)*8192)/(1024*1024) "shrinkage_possible in MB" from dba_data_files a, ( select file_id, max(block_id+blocks) hwm from dba_extents where tablespace_name ='&1' group by file_id ) b where a.file_id = b.file_id and a.tablespace_name='&1';

    ReplyDelete

Subscribe to: Post Comments (Atom)