Oracle-L: Re: table size.

From: mitchell <mitchell_at_comnet.ca>
Date: Mon, 08 Jul 2002 10:28:40 -0800
Message-ID: <F001.00491589.20020708102840@fatcity.com>

RE: table size.Hi Godlwski

Thanks for your reply.

This is not locally managed tablespace and num_rows are the same. The following result from dba_tables. This big different is empty_blocks.

I still confused why the size is the same but with much more empty_blocks.

I think the empty_block means never used. If whole block data is deleted, what happed to this column? used but emptied?

Mitchell

exported table

TABLE_NAME                     EMPTY_BLOCKS  CHAIN_CNT     BLOCKS  AVG_SPACE
------------------------------ ------------ ---------- ---------- ----------
STATEMENT_LINE                           30                     0                        40401        421

2. imported table

TABLE_NAME                     EMPTY_BLOCKS  CHAIN_CNT     BLOCKS  AVG_SPACE
------------------------------ ------------ ---------- ---------- ----------
STATEMENT_LINE                        46099                        0                   35225        421

Original Message ----- From: Godlewski, Melissa To: 'mitchell_at_comnet.ca' Sent: Monday, July 08, 2002 12:54 PM Subject: RE: table size.

Mitchell,

Is this table in a Locally Managed Tablespace? If so your extents might be the issue. Check blocks and empty blocks, and num_rows in dba_tables. (after an analyze of course)

  -----Original Message-----
  From: mitchell [mailto:mitchell_at_comnet.ca]   Sent: Monday, July 08, 2002 1:28 PM
  To: Multiple recipients of list ORACLE-L   Subject: Re: table size.

Sorry : table is 8 million rows and I deleted 5 million rows.

Original Message ----- To: <ORACLE-L_at_fatcity.com> Sent: Monday, July 08, 2002 12:20 PM

>
> Hi all
>
> I have a table with 8 millions rows and I deleted the 500 million. Then I
> exported tables (300 mb) and imported into another schema. After that, the
> table size is still the same.
>
> I thought table size should be taken much less space. the storage clause
for
> both table is the same: pct10,pctused 40.
>
> any idea.
>
> Mitchell
>
>
>
>
>

  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com   --
  Author: mitchell
    INET: mitchell_at_comnet.ca

  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: mitchell
  INET: mitchell_at_comnet.ca

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).

Received on Mon Jul 08 2002 - 13:28:40 CDT