Hello Gurus, How to size, calculate the temporary tablespace based on database total size OR database growth?, One of our application support raised a tar on high open cursor count and they inturn asked the DBA's to size appropriately the TEMP tablespace. Could anyone please advice on this? I am mainly looking out scenarios to handle the TEMP issues and one of the reason is high open cursor count which is causing the performance issue. Also we have a dataware house database where they run data to load every 2 hours. Even their process got failed because of TEMP space unable to extend, and had to restart the job post temp space addition. I have least idea on how to size the TEMP space required for a particular activity. Please let me know any links to refer as well( Metalink notes). Thanks in anticipation. Thanks, Ann