Re: When to expect the next extent of table?

First, You can estimate size of used block in table. Each row has rowid and rowid is composed of block ,row and file. So, select count(*) from (select distinct substr(rowid,1,8) from USER_TABLE)) will display used block.

Next, You can check number of extents.
DBA_EXTENTS will display extent size,number and etc.

Thanks.

Young-chul,Jun ycjun_at_hotmail.com
OCP
SAMSUNG SDS, KOREA Ng TC ÀÌ(°¡) <6uevf0$t7a$1_at_newton2.pacific.net.sg> ¸Þ½ÃÁö¿¡¼­ ÀÛ¼ºÇÏ¿´½À´Ï´Ù...
>
>Hi,
>
>How do I check if a table (or other objects) will be creating the next
>extent (which dynamice views, dba_ views??)?
>
>How do I check how much of the current extent is being used?
>
>Thanks in advance.
>
>Regards,
>Tse Chong
>
>(Please reply trhough email: tcng_at_yas.com.sg )
>
>
>
Received on Fri Sep 25 1998 - 00:00:00 CDT