All,
Thanks for the replies.
We had to set the kernel parameter 'fifo_do_adaptive = 0',
like pointed out by some people.
True64 is doing a kind of buffering when he is piping data
between processes. It seems that Oracle 8.1.7 has problems
with this mechanism. By setting 'fifo_do_adaptive' to 0, the
buffering is disabled and the performance turned back to normal.
Regards,
Rob.
Some of the replies :
Abdul.Rahiman_at_spx.com :
Couple of comments about your performance issues with
GS160.
First, you shd be thinking seriously to upgrade to unix v5.1
which is NUMA aware and use the features like
gh_rad_regions,run on commands etc.
Other thing, you may turn off numa feature of oracle
by re-linking oracle binaries with numa off switch.
it goes something like this..
# make -f ins_rdbms.mk numa_off
# make -f ins_rdbms.mk ioracle
pls. make sure that you have the right info from oracle
documentation about these commands.
hope this helps..
Abdul Rahiman,
UNIX Administrator.
Lee_Brewer_at_discovery.com :
Rob,
We just recently purchased a GS160 and upgraded to Orcale 8.1.6. We at
first
had problems with performance. The first round of tuning was done by
the DBA's,
some of the settings that were changed in the upgrade caused performance
hits
for us. So they tweaked them. The biggest boost came from changing the
shared
memory settings ...
we set
ssm_threshold = 0
and for each QBB used we took the sizes of the SGA's / Number of QBB =
gh_rad_region() value for each QBB
basically we hardwired memory for shared memory to each QBB
Example SGA 900 MB
we have 3QBB's
then at least
gh_rad_region(0)=300
gh_rad_region(1)=300
gh_rad_region(2)=300
be careful not to go under your shared memory requirements.... allow
for other
programs.. you can check it out by
ipcs -am
Also be aware that if you use direct I/O with a filesystem there is a
bug in 5.1
and 5.1 clustering concerning clonefilesets... when you do move up to
5.1 check
with Compaq...Happy Hunting
Lee Brewer
Phil Baldwin <baldwinp_at_EURODIS.com>
Hi Rob,
you can switch numa-awareness on or off. It's not compulsory
I include a patch kit release txt file that (Patch Set Notes.rtf) has
info
on enabling / disabling numa-awareness hopefully in bold.
<<Patch Set Notes.rtf>>
Please note the bit about sysconfig parameters. The one that made the
most
difference for us was
fifo_do_adaptive = 0, although configuring rad_gh_regions and
ssm_threshold
correctly makes a difference.
If I can help further, please email me.
BTW we were running 7.3.4.5 and have migrated to 8.1.7 this year, and it
does seem to be quite a bit slower . That's progress, I guess.
Regards
Phil
Question :
All,
Since we upgraded from ORACLE 8.0.6 to 8.1.7 ,
we are experiencing a severe performance lost.
System : GS160, 8 CPU's / 8 GB Memory; True64 4.0G
I'm wondering if somebody had similar problems ?
The GS160 has a NUMA architecture and Oracle 8.17 is
NUMA aware, while True64 version 4.0G is not. Is there
somewhere a 'hidden feature' in Oracle 8.1.7. to force it
to run like on a SMP system, disregarding the NUMA
awareness ?
Regards,
Rob.
email : rob.pieters_at_eds.com
Received on Fri Dec 21 2001 - 22:26:57 NZDT