Re: Table and schema current size.

Hi,
try procedure dbms_space.unused_space.
See OUT parameters TOTAL_BLOCKS, TOTAL_BYTES. Ales

SQL> desc dbms_space
PROCEDURE FREE_BLOCKS

 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 SEGMENT_OWNER                  VARCHAR2                IN
 SEGMENT_NAME                   VARCHAR2                IN
 SEGMENT_TYPE                   VARCHAR2                IN
 FREELIST_GROUP_ID              NUMBER                  IN
 FREE_BLKS                      NUMBER                  OUT
 SCAN_LIMIT                     NUMBER                  IN     DEFAULT
 PARTITION_NAME                 VARCHAR2                IN     DEFAULT
PROCEDURE UNUSED_SPACE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 SEGMENT_OWNER                  VARCHAR2                IN
 SEGMENT_NAME                   VARCHAR2                IN
 SEGMENT_TYPE                   VARCHAR2                IN
 TOTAL_BLOCKS                   NUMBER                  OUT
 TOTAL_BYTES                    NUMBER                  OUT
 UNUSED_BLOCKS                  NUMBER                  OUT
 UNUSED_BYTES                   NUMBER                  OUT
 LAST_USED_EXTENT_FILE_ID       NUMBER                  OUT
 LAST_USED_EXTENT_BLOCK_ID      NUMBER                  OUT
 LAST_USED_BLOCK                NUMBER                  OUT
 PARTITION_NAME                 VARCHAR2                IN     DEFAULT

Peter Shvets <pshvets_at_powermarket.com> wrote in message news:9hamoe$1rlg$1_at_news.mainstreet.net...
> Hello, dear friends.
> I need to find out how big is every single table in the schema I have as
> well as the size of the schema itself.
> I am not a DBA, so I apologize for too simple question. :)
>
> Thanks in advance.
>
> Peter Shvets.
>
>
Received on Sat Jul 21 2001 - 16:24:34 CDT