Diferences between Free(MB) and Total free space(MB)

[Former Member]

What are the differences between these columns from DB02 for tablespaces:

Columns:

Size(MB)

Free(MB)

Used(%)

Columns:

Total size(MB)

Total free space(MB)

Total used(%)

Which columns should be used to determine the free space the tablespace can receive more data to store: Free(MB) or Total free space(MB)?

Comparing the numbers for these, they have different values.

Edited by: Yosemite Sam on Jan 4, 2010 8:47 PM

[former_member204746 · Accepted solution]

the columns on the left uses raw values for its calculation. this is actual disk space used.

the columns on the right (Total) take auto-extendable datafiles into its calculation.

so, it's up to you what you prefer. I use the TOTAL column myself.