What is avg_space column in user_tables mean?

What is the column 'avg_space'  for in the 'user_tables' data dictionary view?
What are the things which affect the value of avg_space?
Does the parameter db_block_size affect this?

Thanks in  advance -- Srikumar
srikumar_pAsked:
Who is Participating?
 
altenaConnect With a Mentor Commented:
'avg_space' is the average amount of bytes used by records in
the table.

It depends on
1. the size and data type of the fields in the table
2. the number of records that have NULL values for 1 or more
   fields.

db_block_size is hardly related. db_block_size is the unit in
which oracle reads and writes from the datafile.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.