Re: Block Rows

From: Brian P. Mac Lean <brian.maclean_at_teldta.com>
Date: 1997/05/09
Message-ID: <33738AE6.22F9@teldta.com>#1/1

gustavo wrote:
>
> How can I count the total "populated" rows in a block ?
> QUERY_HITS don't reflect created rows.
>
> Regards,
>
> Gustavo S. Tamaki
> gstamaki_at_pobox.com

Is this what you want?.....

SQL> r
1 select substr(rowid,15,4) FILEID, substr(rowid,1,8) BLOCK, count(*) 2 from sys.obj$
3 group by substr(rowid,15,4), substr(rowid,1,8) 4* order by 1,2

FILE BLOCK COUNT(*)
---- -------- ----------

0001 0000005C         71
0001 0000005D         67
0001 000001D5         63
0001 000001D6         63
0001 000001D7         60
0001 00000252         60
0001 00000253         61
0001 00000254         61
0001 00000255         60
0001 00000256         61
0001 000002F0         68
0001 000002F1         61
0001 000002F2         60
0001 000002F3         63
0001 000002F4         62
0001 000002F5         60
0001 000002F6         59
0001 000002F7         18
0001 000002F8          9
0001 000002F9         58
0001 000007DA         62
0001 000007DB         53
0001 000007DC         38

23 rows selected. Received on Fri May 09 1997 - 00:00:00 CDT