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

From: Holman, Rodney <rodney.holman_at_lodgenet.com>
Date: Tue, 24 Oct 2000 12:30:07 -0500
Message-Id: <10659.120064@fatcity.com>

Yes,

SELECT TABLE_NAME, SUM(NUM_ROWS*AVG_ROW_LEN) BYTES FROM DBA_TAB_PARTITIONS
GROUP BY TABLE_NAME; Rodd Holman
Enterprise Data Systems Engineer
LodgeNet Entertainment Corporation
rodney.holman_at_lodgenet.com
Comments made are my own opinions and views. They do not represent views, policies, or procedures of LodgeNet Entertainment Corporation

-----Original Message-----
From: Arun Jacob Muthalaly [mailto:arun_jacob_at_0racledba.com] Sent: Tuesday, October 24, 2000 9:32 AM
To: Multiple recipients of list ORACLE-L 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:30:07 CDT