DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Table size

  1. #1
    Join Date
    Nov 2000
    Posts
    101
    Hi,

    How shall we find out the size of the tables?
    We know to find out the size of the tablespace, could any one tell me thesyntax?


    Thanks in advance,


    bye
    gandhi

  2. #2
    Join Date
    Mar 2001
    Posts
    41
    Maybe the DBA_SEGMENTS view will help. There is a column name BYTES.

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    if i am able to undersatnd your question right and what you wanted is the amount of space that is alocated to a table then just use the following query.

    SELECT SEGMENT_NAME,SUM(BYTES)
    FROM DBA_SEGMENTS
    WHERE SEGMENT_TYPE='TABLE'
    GROUP BY SEGMENT_NAME

    hth

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width