Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: num of blocks containing table data
Look at $ORACLE_HOME/rdbms/admin/dbmsutil.sql
There is a package called dbms_space which uses internal C routines to read the high water mark (and free list chains) very efficiently.
This applies to 7.3+ and 8.0+
Jurij Modic <jurij.modic_at_mf.sigov.mail.si> wrote in article
<357d0431.12187614_at_www.sigov.si>...
> On Tue, 09 Jun 1998 13:36:12 +0500, Umar FArooq
> <umar.farooq_at_cressoft.com.pk> wrote:
>
> You can write a query to count all distinct "file and block
sections"
> of rowids of that table. For Oracle7 you can use:
>
> SELECT COUNT(DISTINCT SUBSTR(rowid,1,8) || SUBSTR(rowid,15,4))
> FROM mytable;
>
> In Oracle8, the format of ROWID has changed, check the manuals
about
> the exact format.
>
Received on Tue Jun 09 1998 - 15:45:32 CDT