Search code examples
oracle-databasesizerow

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


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


Solution

  • 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