I get temp file limit exceeds error, it set 2G, what number should be

Question

hi all, I get temp file limit exceeds error, it set 2G, what number should be set, and how to understand set true value? If I set to 10G, what harm can it do