Here's a link to a script that I published in Nov 2000 demonstrating the principle: http://www.jlcomp.demon.co.uk/faq/rowsize.html I have a modern variant which still has the limitation that it can only handle simple data types (no LOBs etc.), and uses sys_op_opnsize() rather than vsize(). The biggest benefit, though, is that it generates the SQL from a supplied tablename. Regards Jonathan Lewis http://jonathanlewis.wordpress.com/all_postings Author: Oracle Core (Apress 2011) http://www.apress.com/9781430239543 -- //www.freelists.org/webpage/oracle-l
