iple recipients of list
ORACLE-L
Spot.com>
cc:
Sent by:
Subject: RE: Database using 100% of
CPU
t.com>cc:
Sent by: Subject: RE: Database using 100% of CPU
root@fatcity.
f list ORACLE-L <[EMAIL PROTECTED]>
>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.
&
According to Control Panel -> System, it's a "x86 Family 6 Model8 Stepping
6". And there are two CPUs.
What's the nature of the bug? Can I find out more about it on MetaLink?
Thanx,
Mike
---
===
Michael P. Vergara
Oracle
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 wit
41 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Database using 100% of CPU
Steven:
I also have this happen on one of our smaller DBs running NT. I
haven't
found a cause yet either. Rebooting seems (so far) to be the only
cure.
aritimes, MPO
E-Mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-Original Message-
From: Vergara, Michael (TEM) [SMTP:[EMAIL PROTECTED]]
Sent: Friday, August 17, 2001 4:22 PM
To: Multiple recipients of list ORACLE-L
Subject:
But it only works at 8.1.6 and above, right? That's what it says on the
doco, and I've been too chicken to try it elsewhere. The database I'm
having issues with is at 8.0.5.
Thanx,
Mike
---
===
Michael P. Vergara
Oracle DB
ailto:[EMAIL PROTECTED]>
-Original Message-
From: Vergara, Michael (TEM) [SMTP:[EMAIL PROTECTED]]
Sent: Friday, August 17, 2001 4:22 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Database using 100% of CPU
I've looked at the s
Check to see if there are any DBMS_JOBS running.
At one place I worked, someone installed some sort of Java monitoring tool on the
database and that pegged the CPU.
In your rdbms/admin directory you need to read the statspack.doc which will tell you
everything you need to do. Very simple.
Th
System_event.
Check out www.vampired.net you will find some articles on statspacks, about
three.
They should give you a very good understanding of statspack.
Highly recommend you becoming familiar with it, it is a very good tool.
"Do not criticize someone until you walked a mile in their shoe
Oracle Certified DBA)
-Original Message-
From: Vergara, Michael (TEM) [SMTP:[EMAIL PROTECTED]]
Sent: Friday, August 17, 2001 2:41 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Database using 100% of CPU
Steven:
I also
In my case, I have a Preproduction environment that is an almost-exact
copy of production. The Production server executes this query in about 20
seconds. The PREproduction machine takes 5-6 minutes. I have watched the
WinNT 'Perfmon' tool monitor the system.
The query is a full table scan of
Which are the event tables, and how do I run the statspack report?
There are no jobs and no active sessions (except mine, and its not me...).
Thanks,
Steven H.
-Original Message-
Spence
Sent: 17 August 2001 18:35
To: Multiple recipients of list ORACLE-L
Have you looked at the event ta
It is nt, it is because it is unstable and crashes every 1 second, you just
haven't noticed it.
Seriously though, first verify the processes are oracle and not something
else using task manager.
Then if they are oracle. Look into v$session and find active sessions.
Trace them back with their sq
.
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Vergara, Michael (TEM) [SMTP:[EMAIL PROTECTED]]
Sent: Friday, August 17, 2001 2:41 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Database using 100% of
Have you looked at the event tables?
Perhaps running a statspack report from now to the next 10 minutes and look
at the biggest waiters.
If it is unix, look for the process which is eating up the resources, query
v$process to get the process address, then use that to get the session, then
use th
Steven:
I also have this happen on one of our smaller DBs running NT. I haven't
found a cause yet either. Rebooting seems (so far) to be the only cure.
If you get any replies would you please summarize to the list?
Thanx,
Mike
---
==
18 matches
Mail list logo