use dba_tables avg_row_len there are ways to calculate it pretty close. I saw some papers on the web that tell you how much storage space each data type uses. but there is also row level overhead. I think that is described on metalink.
avg_row_len is usually enough. > > From: "NGUYEN Philippe (Cetelem)" <[EMAIL PROTECTED]> > Date: 2003/08/04 Mon AM 06:54:26 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: size of a row > > Hi list, > sorry because the question is certainly already posted : > How can I calculate a size of one row in my Table ? > Thanks in advance! > Philippe > >Title: size of a row
Hi list,
sorry because the question is certainly already posted :
How can I calculate a size of one row in my Table ?
Thanks in advance!
Philippe
