How to size, calculate the temporary tablespace based on database total size OR database growth?
- From: "Shastry(DBA)" <shastry17@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 25 Oct 2008 19:17:44 +0530
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
Other related posts:
