Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)

Part Number A89852-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

DBMS_SPACE, 2 of 4


UNUSED_SPACE Procedure

This procedure returns information about unused space in an object (table, index, or cluster).

Syntax

DBMS_SPACE.UNUSED_SPACE (
   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

Table 60-2 UNUSED_SPACE Procedure Parameters
Parameter  Description 
segment_owner
 

Schema name of the segment to be analyzed. 

segment_name
 

Segment name of the segment to be analyzed. 

segment_type
 

Type of the segment to be analyzed:

TABLE 
TABLE PARTITION 
TABLE SUBPARTITION 
INDEX 
INDEX PARTITION 
INDEX SUBPARTITION 
CLUSTER 
LOB 
 
total_blocks
 

Returns total number of blocks in the segment. 

total_bytes
 

Returns total number of blocks in the segment, in bytes. 

unused_blocks
 

Returns number of blocks which are not used. 

unused_bytes
 

Returns, in bytes, number of blocks which are not used. 

last_used_extent_ file_
id
 

Returns the file ID of the last extent which contains data. 

last_used_extent_ 
block_id
 

Returns the block ID of the last extent which contains data. 

last_used_block
 

Returns the last block within this extent which contains data. 

partition_name
 

Partition name of the segment to be analyzed.

This is only used for partitioned tables; the name of subpartition should be used when partitioning is compose. 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback