Re:Finding the actual size of a table

From: <dgoulet_at_vicr.com>
Date: Tue, 30 May 2000 15:41:33 -0400
Message-Id: <10513.107164@fatcity.com>

Check out DBMS_SPACE.UNUSED_SPACE.

____________________Reply Separator____________________

Subject: Finding the actual size of a table Author: Steven Monaghan <Steve.Monaghan_at_wcom.com> Date: 5/30/00 11:52 AM

Which data dictionary view can I use to determine the actual size of a table, not just the extents allocated to it?

I will be moving a database to a new machine in a few weeks, and I want to start planning out the initial extent sizes for my tables. I don't want to just use exp/imp with compress=Y because I want to manually size some of my smaller reference tables with a large enough initial extent so they don't need to grow to reduce potential fragmentation.

I also have TOAD but couldn't find the answer there either.

TIA,
Steve Monaghan
WorldCom

-- 
Author: Steven Monaghan
  INET: Steve.Monaghan_at_wcom.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).

Received on Tue May 30 2000 - 14:41:33 CDT