RE: used segment space in bytes

From: Deepak Thapliyal <deepakthapliyal_at_yahoo.com>
Date: Thu, 17 Jan 2002 16:41:18 -0800
Message-ID: <F001.003F35FD.20020117160541@fatcity.com>

Hi Do,

Here is the breakup for a space usage for a segment:

Allocated size (use dba_segments)

2 Used Blocks in segments(use dba_tables.blocks)

     --> Truly Used ( ??)
     --> Free Blocks (??)

3. Unused Blocks (use dba_tables.empty_blocks)

the caveat i guess is in step 2. The used block number is based on the high watermark. which means that the number you will get for point 2. above will also include "space that contains no rows" becuz its below the high water mark.

Afaik, there is'nt a way to find these "free blocks" below the high water mark.. unless you re-build table and then get the value from dba_tables.blocks ..

feel free to correct me ..

Deepak

> -----Original Message-----
> Sent: Thursday, January 17, 2002 12:12 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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
>
>
>

Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: deepakthapliyal_at_yahoo.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 Thu Jan 17 2002 - 18:41:18 CST