RE: used segment space in bytes

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Thu, 17 Jan 2002 10:50:12 -0800
Message-ID: <F001.003F3005.20020117102202@fatcity.com>

What about dba_segments?

  <FONT
  face=Tahoma>-----Original Message-----From: Oberkofler, Dieter   [mailto:d.oberkofler_at_leadingbits.at]Sent: Thursday, January 17,   2002 12:12 PMTo: Multiple recipients of list   ORACLE-LSubject: used segment space in bytes   hi guys!

  what would be the easiest way to compute   the space
  in bytes used by a segment?
  it is rather easy to determine the # of   used blocks
  by a specific segment by looking at the   dba_extents
  for example. but how many blocks have been   really used
  in one of those extents. i guess i would   be able
  to compute the free blocks by using the   dbms_space
  package but it just seems to
  complicated.
  any hints ... ?

  thank you

  -do
  <SPAN
class=258400017-17012002> Received on Thu Jan 17 2002 - 12:50:12 CST