Re: Space used within an extent

From: Saad Ahmad <sahmad_at_mfa.com>
Date: 1996/04/26
Message-ID: <4lrf06$269_at_homer.alpha.net>#1/1


Sid Poondla (xsid_at_msg.ti.com) wrote:
> Is there any Oracle 7.x data dictionary view that shows how much space
> is used within an extent.

Try
select count( distinct substr(rowid,1,8) || substr(rowid,15,4) )  from &the_table;

This would give you the blocks in use by the table. Using dba_extents along with this number you can see how full your current extent is.

--
**************************************************************
*                          Saad Ahmad                        *
*                          Senior Software Engineer          *
*                          McHugh Freeman & Associates, Inc. *
*                          Ph:  (414) 798-7457               *
*                          Fax: (414) 798-8619               *
*                          E-Mail: sahmad_at_mfa.com            *
**************************************************************
Received on Fri Apr 26 1996 - 00:00:00 CEST

Original text of this message