REMEMBER that empty_blocks represent the amount of
blocks above the HWM. The only way to know the blocks
below the HWM is with this select:
on 7.X select count(distinct
substr(rowid,15,4)||substr(rowid,1,8)) from
&owner..&table_name.;
on 8.X select count( distinct substr(rowid,1,15)) from
&owner..&table_name.;
This gives you the real space occupy by a segment or
as I said the amount of blocks below the HWM. Then
with the db_block_size you can infer the value in
bytes.
Regards.
- Vladimir Begun <jester_at_whale.sunbay.crimea.ua>
wrote:
> on Jul 11, 2001 at 11:30:18PM, Chuan Zhang wrote:
> > Hi, DBA gurus,
> >
> > Recently, I will archiving some big tables. How
> to find free space under
> > HWM for a table?
>
> Do analyze and then you can calculate it:
>
> dba_segments.blocks - dba_tables.empty_blocks - 1
>
> Be aware the blocks which are below HWM can be empty
> because of preallocation or delete activities.
>
> --
> Vladimir Begun | echo
> "Congratulations. You aren't running
> http://vbegun.net/ | Eunice."
> http://vbegun.net/wap/ | -- Larry Wall
> in Configure from
> me_at_vbegun.net | the perl
> distribution
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Vladimir Begun
> INET: jester_at_whale.sunbay.crimea.ua
>
> 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).
Eng. Christian Trassens
Senior DBA
Systems Engineer
ctrassens_at_yahoo.com
ctrassens_at_hotmail.com
Phone : 541149816062
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christian Trassens
INET: ctrassens_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 Jul 12 2001 - 02:49:32 CDT