] On
Behalf Of Ravi Kulkarni
Sent: Thursday, July 10, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RAC system Calls
Matt,
What are jumbo frames? Are these assigning private
network IPs to cluster_interconnects parameter?
-Ravi.
--- Matthew Zito [EMAIL PROTECTED
Just for fun, have you tried using truss to find out which calls
are being used? That might help you.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, July 10, 2003 8:14 PM
To: Multiple recipients of list ORACLE-L
Raj,
Yes.
Title: RE: RAC system Calls
That may be because with RAC there is more activity ... GCS traffic and more stats to update ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email
Mladen, As mentioned earlier, I have lots of times
funtion calls, which (my guess) relate to (60-70%)IPC
send completion sync waits I got in statspack. Dont
mean to fill your inboxes, but, pasting few truss
lines:
26949: read(14, 01 O\0\006\0\0\0\0\011 i.., 2064)
= 335
26949:
The times call is very cheap and could not possibly consume so much time.
Here is what man page says:
NAME
times - get process and child process times
SYNOPSIS
#include sys/times.h
clock_t times(struct tms *buffer);
DESCRIPTION
times() fills the structure pointed to
Title: RE: RAC system Calls
Raj:
I am
discussing this issue with Ravi offline. From the initial
IPC
dumps, It looks like the private interconnect is not
properly configured/used for cache fusion. I am waiting
for
more
details from him..
Best Regards,K Gopalakrishnan
-Original
Title: RE: RAC system Calls
Hmmm ...
Thanks KG
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts, having an opinion
Correct. Looks like we need to configure
CLUSTER_INTERCONNECTS parameter. Automatic
configuration (Sun Cluster3.0/RAC) did not choose the
(correct) IP(s) for interconnect. KG noticed it. I
have sent netstat -ai, oradebug IPC dump, ping -s info
to him. If you are interested, I can paste it here.
Title: RE: RAC system Calls
We don't use cluster_interconnects (it is null) ... but for us, the RAC is using the fat private interconnects without any problems.
Raj
Rajendra dot Jamadagni at nospamespn dot com
Do you use 1 or 2 interconnects? Does your oradebug
ipc dump show both IPs? For me shows:
SSKGXPT 0x3066b00 flags info for network 0
socket no 9 IP 172.168.193.2 UDP 41143
sflags SSKGXPT_UPinfo for network 1
socket no 0 IP 0.0.0.0 UDP 0
Title: RE: RAC system Calls
Yup, we have 2 private interconnects and one public .. can't display the ips though ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email
I have tested using cluster_interconnects parameter.
Oradebug IPC dump shows it chooses first IP correctly,
recognizes the 2nd interconnect, but with a wrong IP -
0.0.0.0. Looks like a bug.. Has anyone seen this
earlier?
(I understand there is a bug in HP with similar
behaviour - we are on
I've seen a problem with CLIC interface, which are, for some
reason, not used by oracle. It is a bug (Oxford is on HP-UX)
and there is a specific one-off patch. This was OPS, not RAC.
The symptoms are very similar: one of the processes was spinning
like crazy in the kernel mode. However, RAC !=
Ravi:
Do you have a statspack report? I would like to see that. But
in any case, 45% kernel is just too much?
BTW have you verified the private interconnect is used
for cache fusion transfer.. Make sure the cache fusion
is not going thru the public network.
Best Regards,
K Gopalakrishnan
I had a similar experience on OPS when we tried with
releasable locks. What is the platform? What kind of
interconnect do you have?
On 2003.07.10 12:44, K Gopalakrishnan wrote:
Ravi:
Do you have a statspack report? I would like to see that. But
in any case, 45% kernel is just too much?
BTW have
Title: RE: RAC system Calls
You seem to have timed_statistics=TRUE right ?? in RAC you will ALWAYS see GCS pings ... basically as long as cluster_database=true, even if only one node is running, you will still see Oracle trying to ping other instances.
My guess is that's what is happening
Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of K Gopalakrishnan
Sent: Thursday, July 10, 2003 11:44 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: RAC system Calls
Ravi:
Do you have a statspack report? I would like to see that. But
in any case
, 2003 11:44 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: RAC system Calls
Ravi:
Do you have a statspack report? I would like to
see that. But
in any case, 45% kernel is just too much?
BTW have you verified the private interconnect is
used
for cache fusion
] [mailto:[EMAIL PROTECTED] On
Behalf Of Ravi Kulkarni
Sent: Thursday, July 10, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RAC system Calls
Matt,
What are jumbo frames? Are these assigning private
network IPs to cluster_interconnects parameter?
-Ravi
://www.gridapp.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Behalf Of Ravi Kulkarni
Sent: Thursday, July 10, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RAC system Calls
Matt,
What are jumbo frames? Are these assigning
Raj,
Yes. Timed_statistics=true. But I see the 'times' even
in single instance(non-rac)database but relatively
called negligible number of times.
-Ravi.
--- Jamadagni, Rajendra
[EMAIL PROTECTED] wrote:
You seem to have timed_statistics=TRUE right ?? in
RAC you will ALWAYS see
GCS pings ...
Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Ravi Kulkarni
Sent: Thursday, July 10, 2003 7:04 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RAC system Calls
Hey Matt,
Thanks for the useful info.
into a smaller number of ethernet frames
22 matches
Mail list logo