Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Block count usage by a table

Block count usage by a table

From: <johnvue_at_gte.net>
Date: Mon, 06 Jul 1998 03:08:02 GMT
Message-ID: <6npf4n$8aa$1@news-1.news.gte.net>


I see the following query mentioned to find out how many blocks a table is using up:

select COUNT(DISTINCT(SUBSTR(ROWID,1,8)||SUBSTR(ROWID,15,4)))

      Blocks_Used
 from sometable;

If most/all of the rows are chained/migrated, won't this query be inaccurate? Received on Sun Jul 05 1998 - 22:08:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US