| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: dbms_free_space for Oracle 8i (Partitioned Tables/Indexes)
Hi,
Is there any way to calculate the Total Size of a partitioned table rather than calculating it individually for each partition.
Cheers
Arun J
--- "Suhen Pather" <PatherS5_at_telkom.co.za>
> wrote:
>Hi Arun
>
>For partitioned tables you need to put in the partition name after the
>last variable (OUT)(7th).
>
>desc dbms_space
>This will give you the input parameters.
>
>HTH
>Suhen
>
>
>
>>>> arun_jacob_at_0racledba.com 10/24/00 12:40PM >>>
>Hi,
>
>Could you please tell me how to modify the following script for Oracle
>8i (Partitioned Tables/Indexes).
>
>Cheers
>
>Arun J
>
>
> declare
> VAR1 number;
> VAR2 number;
> VAR3 number;
> VAR4 number;
> VAR5 number;
> VAR6 number;
> VAR7 number;
> begin
> dbms_space.unused_space('OPS$CC1','SPACES','TABLE',
>
>VAR1,VAR2,VAR3,VAR4,VAR5,VAR6,VAR7,PARTITION_NAME);
> dbms_output.put_line('OBJECT_NAME = SPACES');
> dbms_output.put_line('---------------------------');
> dbms_output.put_line('TOTAL_BLOCKS = '||VAR1);
> dbms_output.put_line('TOTAL_BYTES = '||VAR2);
> dbms_output.put_line('UNUSED_BLOCKS = '||VAR3);
> dbms_output.put_line('UNUSED_BYTES = '||VAR4);
> dbms_output.put_line('LAST_USED_EXTENT_FILE_ID = '||VAR5);
> dbms_output.put_line('LAST_USED_EXTENT_BLOCK_ID = '||VAR6);
> dbms_output.put_line('LAST_USED_BLOCK = '||VAR7);
> end;
>
>_____________________________________________________________
>Be someone_at_0racledba.com - get your free mail from Oriole Corporation
> http://www.oriolecorp.com - Performance tools for Oracle DBAs
>
>Get email for your site ---> http://www.everyone.net
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Arun Jacob Muthalaly
> INET: arun_jacob_at_0racledba.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Suhen Pather
> INET: PatherS5_at_telkom.co.za
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
 |
 |