Oracle Built−in Packages- P113: Ah, for the good old days of Version of PL /SQL! Life was so simple then. No stored procedures or functions and certainly no packages. You had your set of built−in functions, like SUBSTR and TO_DATE. You had the IF statement and various kinds of loops. With these tools at hand, you built your batch−processing scripts for execution in SQL*Plus, and you coded your triggers in SQL*Forms , and you went home at night content with a good day's work done. | Appendix A What s on the Companion Disk For more information about freelists and how they can be used to minimize contention see the Oracle7 Parallel Server Concepts and Administration manual. The procedure The UNUSED_SPACE procedure returns information about the unused space and the position of the highwater mark in a table index or cluster segment. Specifications for Oracle and Oracle8 differ as follows. Here is the Oracle specification PROCEDURE segment_owner IN VARCHAR2 segment_name IN VARCHAR2 segment_type IN VARCHAR2 total_blocks OUT NUMBER total_bytes OUT NUMBER unused_blocks OUT NUMBER unused_bytes OUT NUMBER last_used_extent_file_id OUT NUMBER last_used_extent_block_id OUT NUMBER last_used_block OUT NUMBER Here is the Oracle specification PROCEDURE segment_owner IN VARCHAR2 segment_name IN VARCHAR2 segment_type IN VARCHAR2 total_blocks OUT NUMBER total_bytes OUT NUMBER unused_blocks OUT NUMBER unused_bytes OUT NUMBER last_used_extent_file_id OUT NUMBER last_used_extent_block_id OUT NUMBER last_used_block OUT NUMBER partition_name IN VARCHAR2 DEFAULT NULL Parameters are summarized in the following table. Name Description segment_owner Schema of segment segment_name Name of segment segment_type Type of segment total_blocks Total data blocks in segment total_bytes Total bytes in segment unused_blocks Total unused blocks in segment unused_bytes Total unused bytes in segment last_used_extent_file_id File id of last used extent last_used_extent_block_id Block id of last used extent last_used_block Last used block in extent partition_name Name of partition only The DBMS_SPACE Interface 551 Appendix A What s on the Companion Disk Exceptions The UNUSED_SPACE procedure does not raise any package exceptions. UNUSED_SPACE will raise the following Oracle exception if invalid segment data is passed in or if the executing user does not have privileges to use .
