?? unused_space.sql
字號(hào):
--* File Name : Unused_Space.sql
--* File Name : Unused_Space.sql
--* Author : DR Timothy S Hall
--* Description : Displays unused space for each segment.
--* Requirements : Access to the DBMS_SPACE package.
--* Call Syntax : @Unused_Space (segment_owner) (segment_name) (segment_type) (partition_name OR NA)
--* Last Modified: 16/05/2001
SET SERVEROUTPUT ON
SET VERIFY OFF
DECLARE
v_partition_name VARCHAR2(30) := UPPER('&4');
v_total_blocks NUMBER;
v_total_bytes NUMBER;
v_unused_blocks NUMBER;
v_unused_bytes NUMBER;
v_last_used_extent_file_id NUMBER;
v_last_used_extent_block_id NUMBER;
v_last_used_block NUMBER;
BEGIN
IF v_partition_name != 'NA' THEN
DBMS_SPACE.UNUSED_SPACE (segment_owner => UPPER('&1'),
segment_name => UPPER('&2'),
segment_type => UPPER('&3'),
total_blocks => v_total_blocks,
total_bytes => v_total_bytes,
unused_blocks => v_unused_blocks,
unused_bytes => v_unused_bytes,
last_used_extent_file_id => v_last_used_extent_file_id,
last_used_extent_block_id => v_last_used_extent_block_id,
last_used_block => v_last_used_block,
partition_name => v_partition_name);
ELSE
DBMS_SPACE.UNUSED_SPACE (segment_owner => UPPER('&1'),
segment_name => UPPER('&2'),
segment_type => UPPER('&3'),
total_blocks => v_total_blocks,
total_bytes => v_total_bytes,
unused_blocks => v_unused_blocks,
unused_bytes => v_unused_bytes,
last_used_extent_file_id => v_last_used_extent_file_id,
last_used_extent_block_id => v_last_used_extent_block_id,
last_used_block => v_last_used_block);
END IF;
DBMS_OUTPUT.PUT_LINE('v_total_blocks :' || v_total_blocks);
DBMS_OUTPUT.PUT_LINE('v_total_bytes :' || v_total_bytes);
DBMS_OUTPUT.PUT_LINE('v_unused_blocks :' || v_unused_blocks);
DBMS_OUTPUT.PUT_LINE('v_unused_bytes :' || v_unused_bytes);
DBMS_OUTPUT.PUT_LINE('v_last_used_extent_file_id :' || v_last_used_extent_file_id);
DBMS_OUTPUT.PUT_LINE('v_last_used_extent_block_id :' || v_last_used_extent_block_id);
DBMS_OUTPUT.PUT_LINE('v_last_used_block :' || v_last_used_block);
END;
/
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -