Re: SMON eating 90% CPU

srivenu schrieb:
> Make sure that you TEMP tablespace is a TEMPORARY TABLESPACE.
> If you wish to improve the concurrency of multiple sort operations,
> reduce their overhead, or avoid Oracle space management operations
> altogether, you should use temporary tablespaces.

Yes, but for this special situation I read somewhere, that my apps can go on working when SMON is cleaning TEMP segments, when I create a temp tablespace which is not TEMPORARY. Of course I'll switch back when SMON finished his work.

Thanks,

Herrmann Received on Fri Mar 12 2004 - 06:53:42 CST