SQL> set serveroutput on
SQL> set pages 1000
SQL> set lines 160
SQL> DECLARE
2 alc_bks NUMBER;
3 alc_bts NUMBER;
4 unsd_bks NUMBER;
5 unsd_bts NUMBER;
6 luefi NUMBER;
7 luebi NUMBER;
8 lub NUMBER;
9 BEGIN
10 DBMS_SPACE.UNUSED_SPACE (
11 segment_owner => 'RNCRY'
12 , segment_name => 'COMS'
13 , segment_type => 'TABLE'
14 , total_blocks => alc_bks
15 , total_bytes => alc_bts
16 , unused_blocks => unsd_bks
17 , unused_bytes => unsd_bts
18 , last_used_extent_file_id => luefi
19 , last_used_extent_block_id => luebi
20 , last_used_block => lub
21 );
22
23 DBMS_OUTPUT.PUT_LINE('Allocated space = '|| alc_bts );
24 DBMS_OUTPUT.PUT_LINE('Actual used space = '|| unsd_bts );
25 EXCEPTION
26 WHEN OTHERS THEN
27 DBMS_OUTPUT.PUT_LINE(SUBSTR(SQLERRM,1,250));
28 END;
29 /
Allocated space = 8534360064
Actual used space = 46874624
PL/SQL procedure successfully completed.
No comments:
Post a Comment