!
- Jerry
- Original Message -
From: "Connor McDonald" [EMAIL PROTECTED]
To: "Multiple recipients of list ORACLE-L"
[EMAIL PROTECTED]
Sent: Wednesday, August 29, 2001 5:27
AM
Subject: RE: OT : kernel using 75% of
CPU
Agreed - and Sun doesn't
handle getting "
Hi, Jerry,
Next time you see top output like shown below, please provide this information:
In SQL*Plus:
select * from v$session_wait where sid = (select sid from v$session where paddr
= (select addr from v$process where spid = 2286));
may need to run it a few times. Post it to the list (or
Jerry,
Be aware that the system performance degardes drastically while truss is
running.
Rao
Maheswara Rao
-Original Message-
Sent: Thursday, August 30, 2001 11:36 AM
To: Multiple recipients of list ORACLE-L
Hi, Jerry,
Next time you see top output like shown below, please provide
Huh? system performance?
URL or source paper, please!
-Original Message-
Sent: Thursday, August 30, 2001 12:42 PM
To: Multiple recipients of list ORACLE-L
Jerry,
Be aware that the system performance degardes drastically while truss is
running.
Rao
Maheswara Rao
-Original
Agreed - and Sun doesn't handle getting close to the
edge at all well imho. Recently upgraded a db on
(2.6) server from 8.0 to 8.1.6 and it went from
running fine to running like an absolute dog - kernel
thrashing exactly like our initial poster reports...
... The problem?
java_pool_size (and
, August 28, 2001 10:46
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
OT : kernel using 75% of CPU
Guy,
Thank you very very much, this is a great
explanation, and is much appreciated.
To answer some of your questions (and add
a few!):
Yes, our client is experiencing
ay, August 28, 2001 11:20
AMTo: Multiple recipients of list ORACLE-LSubject: OT :
kernel using 75% of CPU
Hi there,
I have a Sun e4500, running Solaris 2.7
and Oracle8.1.7.1.0. Everything looks normal from a database
perspective, but when I run "top" it show the kernel be
ubject: OT :
kernel using 75% of CPU
Hi there,
I have a Sun e4500, running Solaris 2.7
and Oracle8.1.7.1.0. Everything looks normal from a database
perspective, but when I run "top" it show the kernel being very
hog-like:
load averages: 14.38, 15.18,
15.18
07:16:
Title: Message
Are you running software raid 10 or software raid 5
on that box?
- Original Message -
From:
Christopher
Spence
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, August 28, 2001 1:30
PM
Subject: RE: OT : kernel using 75% of
CPU
Also
again,
Jerry
- Original Message -
From:
Christopher
Spence
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, August 28, 2001 1:30
PM
Subject: RE: OT : kernel using 75% of
CPU
paging and swapping is the first thing that comes to mind, look at
vmstat
PM
Subject: Re: OT : kernel using 75% of
CPU
Thanks for the reply, Chris.
I'm a bit ashamed, being as old as I am,
that I don't have a better grasp on swapping. I initially thought maybe it was
a swap problem also, but top shows 0.0% swap. I thought I had also checked
vmstat
, August 28, 2001 4:16
PM
Subject: Re: OT : kernel using 75% of
CPU
Does anybody know how I can see how much
memory each process is using under Solaris. On Digital UNIX it was ps -aux, if
I remember correctly...
Thanks!
Jerry
- Original Message -
From
-LSubject: Re:
OT : kernel using 75% of CPU
Does anybody know how I can see how much
memory each process is using under Solaris. On Digital UNIX it was ps -aux, if
I remember correctly...
Thanks!
Jerry
- Original Message -
From:
Jerry C
To: [EMAIL
Title: RE: OT : kernel using 75% of CPU
OOOH yea. Looks like your machinie is awful darn busy !
Lisa Koivu
Certified MOnkey and DBA
Ft. Lauderdale, FL, USA
-Original Message-
From: Jerry C [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, August 28, 2001 4:01 PM
To: Multiple
, August 28, 2001 2:58
PM
Subject: Re: OT : kernel using 75% of
CPU
Thanks for the reply,
Chris.
I'm a bit ashamed, being as old as I
am, that I don't have a better grasp on swapping. I initially thought maybe
it was a swap problem also, but top shows 0.0
ford 01863
-Original Message-From: Jerry C
[mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 4:01
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
OT : kernel using 75% of CPU
Thanks for the reply, Chris.
I'm a bit ashamed, being as old as I am,
that I don't hav
28, 2001 4:17
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
OT : kernel using 75% of CPU
Does anybody know how I can see how much
memory each process is using under Solaris. On Digital UNIX it was ps -aux, if
I remember correctly...
Thanks!
Jerry
- Origin
Jerry,
I think it is time to look at what's happening inside the database. The
following queries will give us an overall idea..
select * from v$system_event order by total_waits desc
select event, count(*) from v$session_wait group by event
I have a feeling that you may see a lot of waits
Hammond
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, August 28, 2001 1:45
PM
Subject: RE: OT : kernel using 75% of
CPU
Hi
Jerry,
Firstly, the kernel is not a process in the
conventional sense. It is basically a set of library func
ORACLE-LSubject: Re:
OT : kernel using 75% of CPU
Guy,
Thank you very very much, this is a great
explanation, and is much appreciated.
To answer some of your questions (and add
a few!):
Yes, our client is experiencing
performance problems.
vmstat and swap -s seem
Jerry,
Riyaj is right - latch contention would not show up against the kernel
counters. A cursory glance shows that there is no problem from your database
side of things. I would pursue the options suggested by Riyaj and Kevin...
John
-Original Message-
Sent: Tuesday, August 28, 2001
everybody for your
suggestions!
- Jerry
- Original Message -
From: "John Kanagaraj" [EMAIL PROTECTED]
To: "Multiple recipients of list
ORACLE-L" [EMAIL PROTECTED]
Sent: Tuesday, August 28, 2001 5:36
PM
Subject: RE: OT : kernel using 75% of
CPU
22 matches
Mail list logo