DB Space - Total / Free Size

[former_member199632]

Here is the DB space usage in our system:

Size - 159.55 GB

Free Size - 19.71 GB

Used - 88%

-

---

Total Size - 220.78 GB

Total Free Size - 80.94 GB

Total Used - 63%

pl, let me know what is the different between these "Size" and "Total Size".

also

"Free Size" and "Total Free Size"

- What will happen when it reach to 100% (when 19.71 GB is over). There do we need to add datafiles ?

(currently all the tablespaces are in auto-extended mode)

and

what will happen when the total free size is over (80.94 GB)

(There do we need to add additional storage)

regards

Edited by: zerandib on Sep 8, 2010 7:20 AM

[Former Member · Accepted solution]

pl, let me know what is the different between these "Size" and "Total Size".

I dont fully understand your question. But if you are referring values from DBA cockpit (or DB02)

Then Size refers to the total "current" size of all the database data files.

Your data files are set to auto extend with a maximum size specified. "Total size" refers to the toal size of all the datafiles considering the max size value specified for auto extend (or filesystem limit).

Hence, "Total Free Size - 80.94 GB" is the free space calculated considring data files can grow to the maximum specified limits.

While reaching this limit, you need to add additonal data files to the identified tablespaces either on the exisiting file system or a new filesystem depending on the free space availability there.