How to size, calculate the temporary tablespace based on database total size OR database growth?
Date: Sat, 25 Oct 2008 19:17:44 +0530
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.