This discussion is archived
4 Replies Latest reply: Nov 30, 2012 9:56 AM by vlethakula RSS

How to find out a record size

707580 Newbie
Currently Being Moderated
Hi

How to find out only one record size

For Ex:

Table 1 - Row 100(100 Record (r) data)
Table 2 - Row 50(100 Record (r) data)

So how to find out size in table-1 of 59 record size?
  • 1. Re: How to find out a record size
    Fran Guru
    Currently Being Moderated
    Please check:
    http://dbaspot.com/oracle-server/48495-size-single-record.html
  • 2. Re: How to find out a record size
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    select owner,tablespace_name,segment_name,sum((bytes/1024/1024)) Bytes
    from sys.dba_extents
    where owner in '<USERNAME>' and segment_type='TABLE'
    group by tablespace_name,owner,segment_name
    order by owner,tablespace_name,segment_name, bytes
    http://www.baanboard.com/baanboard/showthread.php?t=13985
  • 3. Re: How to find out a record size
    rp0428 Guru
    Currently Being Moderated
    Welcome to the forum!

    Whenever you post provide your 4 digit Oracle version (result of SELECT * FROM V$VERSION).
    >
    How to find out only one record size

    For Ex:

    Table 1 - Row 100(100 Record (r) data)
    Table 2 - Row 50(100 Record (r) data)

    So how to find out size in table-1 of 59 record size?
    >
    Tell us what YOU mean by 'record size'.

    Some data (numbers, dates) are stored in an internal proprietary format. For example a date value is stored internally using 7 bytes for the value itself but there are also some bytes for overhead. That value can represent 'November 30, 2012 14:23:32' which is 26 bytes if you display the date that way.

    Should the length of that date column be '7' or '26'?

    What about numbers? The number '123000000000000' and the number '123' take the same amount of space internally but when you display them the first one's length is 15 but the second is only 3.

    Should the length of that number colulmn be '15' or '3'?

    See table 2-1 Built-in Datatype Summary in the SQL Language doc.
    http://docs.oracle.com/cd/B28359_01/server.111/b28286/sql_elements001.htm#i54330
  • 4. Re: How to find out a record size
    vlethakula Expert
    Currently Being Moderated
    check, after gathering stats on table

    dba_tables.avg_row_len

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points