Re: How much space do my data occupy?
From: ChrisH7260 <chrish7260_at_aol.com>
Date: 4 Mar 1995 00:56:22 -0500
Message-ID: <3j8ve6$oil_at_newsbf02.news.aol.com>
Date: 4 Mar 1995 00:56:22 -0500
Message-ID: <3j8ve6$oil_at_newsbf02.news.aol.com>
Although, I don't know the exact makeup of ROWID off the top of my
head,...
select sum(distinct(substr(rowidtochar(rowid), 1, 8)))
from table;
To determine the number of blocks actually occupied by a table. Then
multiply by your blocking factor; usually 2k or 4k. That seems to be
pretty
part of it designates a block id. I have used a sql something like
accurate, although I'm not sure that the substr() should start at 1 for
8,...
Chris Hennessy Received on Sat Mar 04 1995 - 06:56:22 CET