Is there an option to limit each user to 10GB of TMP alone?

Solution Description:

No quota can be granted on temp tablespaces, though it is applicable on other regular tablespace. The reason we can’t grant quota on temp tablespace for following 2 reasons:

* 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.

Please refer metalink note 1054952.6 for more information. We need to fix the code that is consuming the whole temp tablespace.

Hi all,

Could you please suggest me on above information.