1. Temp is not a Dictionary Managed Tablesapce
2. with Uniform Allocation
3. Extent management is "Locally"
4. Current size is 4 Gb
with the above points, how big that we can make this temp tablespace? If we make this around 10 G, are there any dependancy parameters? How to find out the what are the programs which consumes this temp tablespace memory?