Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_SPACE, 4 of 4
This procedure shows the space usage of data blocks under the segment High Water Mark. The bitmap blocks, segment header, and extent map blocks are not accounted for by this procedure. This procedure can only be used on tablespaces that are created with auto segment space management.
DBMS_SPACE.SPACE_USAGE( segment_owner IN varchar2, segment_name IN varchar2, segment_type IN varchar2, unformatted_blocks OUT number, unformatted_bytes OUT number, fs1_blocks OUT number, fs1_bytes OUT number, fs2_blocks OUT number, fs2_bytes OUT number, fs3_blocks OUT number, fs3_bytes OUT number, fs4_blocks OUT number, fs4_bytes OUT number, full_blocks OUT number, full_bytes OUT number, partition_name IN varchar2 DEFAULT NULL);
variable unf number; variable unfb number; variable fs1 number; variable fs1b number; variable fs2 number; variable fs2b number; variable fs3 number; variable fs3b number; variable fs4 number; variable fs4b number; variable full number; variable fullb number; begin dbms_space.space_usage('U1','T', 'TABLE', :unf, :unfb, :fs1, :fs1b, :fs2, :fs2b, :fs3, :fs3b, :fs4, :fs4b, :full, :fullb); end; / print unf ; print unfb ; print fs4 ; print fs4b; print fs3 ; print fs3b; print fs2 ; print fs2b; print fs1 ; print fs1b; print full; print fullb;
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|