Hello, TEMP space usage is not directly dependent on number of open cursors. You can have a lot of cursors that use no TEMP space at all or you can have one cursor that utilizes all the TEMP space. The main question here is what are your DB sessions doing. There are 2 typical cases when TEMP space is used: 1) sort operations that don't fit into PGA 2) storing data best regards, Maris On Sat, Oct 25, 2008 at 3:47 PM, Shastry(DBA) <shastry17@xxxxxxxxx> wrote: > 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 >