How to determine the biggest float value (in terms of used bytes) with SQL in Oracle?
VSIZE


  VSIZE returns the number of bytes in the internal representation of
  expr.


select max(vsize(mycolumn)) from mytable;