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