Re: Tables - size of extents and number used

From: Davide Bellesi <davide.bellesi_at_visto.com>
Date: Tue, 12 Sep 2000 02:54:08 -0700
Message-Id: <10617.116760@fatcity.com>

Hi,=20
  you should query dba_segments :

   select segment_name, initial_exent,

          next_extent,pct_increase,extents    from dba_segments=20

Hope this helps
Davide

-----Original Message-----
From: John Dunn john.dunn_at_sefas.co.uk Sent: Tue, 12 Sep 2000 00:55:45 -0800 To: ORACLE-L_at_fatcity.com
Subject: Tables - size of extents and number used

What code can I use to find out the storage details for a table and how m= any
extents have been used?

John

--=20
Author: John Dunn
  INET: john.dunn_at_sefas.co.uk

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

_________________________________________________________________________=

__
Visit http://www.visto.com/info, your free web-based communications cente= Received on Tue Sep 12 2000 - 04:54:08 CDT