db02 table space size logic

[Former Member]

hi

when ı look db02 ı see used(%) column value for one tablespace is almost %100 but total used column value is %34.

what is the logic behind this?

regards

[anindya_bose]

May be your tablespace is in AUTO EXTEND mode.

Suppose you have a datafile with Initial Size 20 GB , Maximum SIZE 100 GB

Now, whenever required tablespace will be increased uptp 100 GB. Let's imagine your tablespace is having 35 GB allocated space and out of that 34 GB is filled up. So, it will show almost 99 % is full. But your tablespace can grow up to 100 GB. So, actual space free is 65 GB, which is not yet allocated but will be allocated when 35 GB will be fully used up.

Please also search with "TABLESPACE AUTO EXTEND"

Regards

Anindya

[Former Member]

thanks for your explanation

yes ts is autoextend mode

ı undestand that parameter that must be controlled is total used(%) column for monitoring a ts growth in db02.