Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SMON eating 90% CPU

Re: SMON eating 90% CPU

From: srivenu <srivenu_at_hotmail.com>
Date: 12 Mar 2004 01:17:05 -0800
Message-ID: <1a68177.0403120117.302a9cae@posting.google.com> 





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


Srivenu
Received on Fri Mar 12 2004 - 03:17:05 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US