Guest User

Untitled

a guest
Dec 11th, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. TB1 54 % 90880 41383 49497 46 98304 50 % ONLINE PERMANENT
  2.  
  3. E:ORACLEORADATAxxTB1.DBF 33554416 True 100
  4. F:ORACLEORADATAxxTB1_2.DBF 33554416 True 100
  5. G:ORACLEORADATAxxTB1_3.DBF 25344000 True 100
  6.  
  7. select segment_name, sum(bytes)/1024/1024 as mb
  8. from dba_segments
  9. where tablespace_name='TB1' and segment_type like 'INDEX%'
  10. group by segment_name
  11. order by mb;
  12.  
  13. alter index ind_big_stuff rebuild;
  14.  
  15. exec dbms_space_admin.drop_empty_segments(schema_name=>'HR');
Add Comment
Please, Sign In to add comment