Determining TEMP tablespace size

An Oracle Forms query died with the following error: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

Our DBA wants to know how big to make the TEMP tablespace. How can we determine what size to make the TEMP tablespace, not only to correct the current problem, but so does this not happen again? The Oracle docs have a detailed section on determining table sizes, but nothing (that I could find) about determining an appropriate size for the TEMP tablespace.

As a side question, who should be responsible for determining the size of TEMP, the DBA or the application developers? Received on Wed Jun 14 1995 - 00:00:00 CEST