Re: how to check table size in oracle 9i

From: <vasant.naidu_at_gmail.com>
Date: 17 Jun 2006 03:38:25 -0700
Message-ID: <1150540705.097975.148630@h76g2000cwa.googlegroups.com>

manish wrote:
> how to check table size in oracle 9i
>
> PLz help

Hi,

Let me walk you through a example.

I want to find the size for the following table:

OWNER                          TABLESPACE_NAME

TABLE_NAME

------------------------------ ------------------------------
------------------------------
PERF                           USERS

BACKUP_DETAIL SQL> show parameter db_block_size

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
db_block_size                        integer     8192

You can calculte in 2 ways both are mentioned below:

select owner,segment_name,

           bytes/1024 as totsize_bytes,
           (blocks*8192)/1024 as totsize_block

from dba_segments
where owner='PERF'

     and segment_name='CONN';

OWNER SEGMENT_NA BYTESIZE BLOCKSIZE
------ ---------- ---------- ----------
PERF CONN 64 64 Hope this helps.

Regards,
Vasant Received on Sat Jun 17 2006 - 05:38:25 CDT