This content has been marked as final. Show 4 replies
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
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
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.
check, after gathering stats on table