Question on current size on the table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Question on current size on the table

  1. #1
    Join Date
    Feb 2002
    Posts
    36
    Hi friends,
    It may be a basic question, I need some clarification, I have table and I am inserting record. I want find out How much bytes It occupies, which current size of the table. Is it right
    that if query from Dba_segment. column bytes for that segment name. Pl clarify

    bye
    Siva

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    -- create new temp table
    -- execute 1 or couple of same insert statments
    -- analize this table
    -- see avg row length in all_tables (or dba_tables) view

  3. #3
    Join Date
    Feb 2002
    Posts
    36
    thanks, as u suggested, I have done that, I have got the follwoing result Avg_row_length is 11, Whether is it bytes or Blocks, What is the unit of it. Thanks in advance

    bye
    siva

  4. #4
    Join Date
    Apr 2002
    Posts
    34
    Originally posted by Siva
    thanks, as u suggested, I have done that, I have got the follwoing result Avg_row_length is 11, Whether is it bytes or Blocks, What is the unit of it. Thanks in advance

    bye
    siva
    It is number of bytes.
    VVS Raju
    8i DBA OCP

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