Re: dbms_free_space for Oracle 8i (Partitioned Tables/Indexes)

Why not query dba_segments?

select sum(bytes) from dba_segments where segment_name='your_table_name_here'; ----- Original Message -----
From: Arun Jacob Muthalaly <arun_jacob_at_0racledba.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, October 24, 2000 9:31 AM
Subject: 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).
>
> _____________________________________________________________
> 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
Received on Tue Oct 24 2000 - 12:50:27 CDT