Hi,
Check whether SMON is active ? What is your tablespace status ? Fragmented ? If yes, SMON would be trying to coalesce. Check for the PCTINCREASE at the tablespace level ... if it is greater than 0.. you will have to let SMON clear the fragmentation at tablespace level.
EVEN if you shutdown and restart the instance.. SMON will again the entire process of defragmentation from SCRATCH.. and hence take even longer to clean up...
Check for v$fet or fet$ (Hope i remember the name correctly.. ) You should be able to check for the fragmentation fo tablespaces there and as it is cleared.. that number of count(*) should come down..
If it is on UNIX.. I can say.. check for the Process ID from within ORACLE... and then query the same with
ps -ef | grep
It should show you.. what process it is ..
OR the other way.. run TOP or some utility which says.. what process is taking maximum CPU time.. and check for that process_id in ORACLE.
It seems SMON has kicked off.
Hope this helps..
Bye
Check which process is taking the maximum CPU TIME.
>From: Bond Mike A Contr OC-ALC/TILC
>Reply-To: ORACLE-L@fatcity.com
>To: Multiple recipients of list ORACLE-L
>Subject: RE: Database using 100% of CPU
>Date: Fri, 17 Aug 2001 13:36:24 -0800
>
>WHat type of processors are in the server. We have a bug - i think in
>8.1.5 or 8.1.6.0 that caused this very problem. Only upgrading the RDBMS
>fixed it.
>
>
>
>
>
>
>-----Original Message-----
>Sent: Friday, August 17, 2001 11:41 AM
>To: Multiple recipients of list ORACLE-L
>
>
>We are having a problem with our database - it is using 100% of the CPU.
>This has only started happening recently, and restarting the database
>temporarily
>stops it happening - it usually recurrs a few hours later.
>There are no jobs running, and at the moment there are no active
>connections.
>Obviously something has kicked this off, can anyone shed any light on this
>or
>suggest how to find out what is running on the db?
>
>
>Thanks in advance,
>
>Steven H.
>
>(Oracle 8.1.6.0.0 EE on NT 4 SP5)
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Steven Hovington
> INET: steven.hovington@procession.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Bond Mike A Contr OC-ALC/TILC
> INET: Mike.Bond@tinker.af.mil
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: H elp_me
INET: good_dba@hotmail.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Sat Aug 18 2001 - 04:05:00 CDT
