Oracle - How do I get the actual size of a specific ROW?

oracle size row
danboh picture danboh · May 3, 2011 · Viewed 50k times · Source

Is this possible? Or at least I'm looking to have a list of the size of all rows in a table.

Answer

bpgergo picture bpgergo · May 3, 2011 
select vsize(col1) + vsize(col2) + vsize(col3) + 
long_raw_length_function(long_col) + DBMS_LOB.GETLENGTH(blob_col) 
from table 
where id_col = id_val;

for the long_raw_length_function, see this Get the LENGTH of a LONG RAW

Related questions

Oracle - ORA-01489: result of string concatenation is too long

Created one view within which one field(of 6) is a concatenation of two fields from the source table. Created a second view that uses listagg to potentially combine the results of the concatenation. Using this two step operation correctly returns …

Read More
Why are Oracle table/column/index names limited to 30 characters?

I can understand that many years ago there would be this kind of limitation, but nowadays surely this limit could easily be increased. We have naming conventions for objects, but there is always a case that turns up where we …

Read More
Oracle NUMBER(p) storage size?

I've searched for it but i can't find a conclusive answer to my question... I need to know what is the storage size of a number(p) field in Oracle. Examples: NUMBER(1), NUMBER(3), NUMBER(8), NUMBER(10) etc...

Read More