4 Replies Latest reply: Nov 30, 2012 11:56 AM by vlethakula RSS

    How to find out a record size

    707580
      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
          Please check:
          http://dbaspot.com/oracle-server/48495-size-single-record.html
          • 2. Re: How to find out a record size
            Osama_Mustafa
            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
              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
                check, after gathering stats on table

                dba_tables.avg_row_len