How to size, calculate the temporary tablespace based on database total size OR database growth?

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

--
http://www.freelists.org/webpage/oracle-l