Does anyone set a quota on the TEMP tablespace for users? If so, is there a value that you start at and then work forwards?
The concept of setting quotas on other tablespaces makes sense to me, but not on TEMP. I've been reading that the PGA, SGA (if using shared server) or TEMP tablespace could be used for sorting data for a user, and so I'm a bit confused on this topic.
Tablespace quotas are not considered during temporary segment creation:
* Temp segments DO NOT consume any quota that a user might possess.
* Temp segments can be created in a tablespace for which a user does not have a quota.
You do not need a parachute to skydive. You only need a parachute to skydive twice.