From: Browett, Darren (dbrowett@coquitlam.ca)
Date: Thu Sep 18 2003 - 19:16:58 EDT
I am researching what appears to be a performance issue, but I am not
sure if it is
tru64 related or oracle related.
I have two environments,
1. A DS10 with 1Gb of memory running 5.1b connected to a HSG80/BA370
SAN, with oracle 8.1.7
2. A DS20E Dual cpu/500Mhz with 4 Gb of memory, clustered with a DS10 (
that's probably bad)
running V5.1b and having Oracle 8.1.7 and 9.2.0.2 RAC connect to a
HSG80/MA3000. The DS20E is hosting
the cluster file systems.
In environment 1, we can run a query and it takes 1-2 secs to return the
result.
On the clustered system the same query can take upto 20 secs, and this
is on a 8.1.7 version and a 9.2.0.2 version of the database
My first instinct would be that the clustered system is "not" production
and therefore the various buffer caches are not loaded
and therefore the query has to go to disk as opposed to memory.
One thing I did find different between the environments, is the
ssm-threshold variable.
I am not sure if this will have any impact on the cluster. According to
oracle this value should be set to zero for 9.2.0.2 RAC/Tru64 setups.
It is set to the default value on the Standalone System.
Could this variable (ssm-threshold) have an impact on my performance ?
Thank You
Darren
------------------------------------------------------------------------
--------------------------------------------------
Darren Browett P.Eng This
message was transmitted
Data Administrator using
100% recycled electrons
Information and Communication Technology
City of Coquitlam
P:(604)927 - 3614
E:dbrowett@coquitlam.ca
------------------------------------------------------------------------
---------------------------------------------------
This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 10:49:36 EDT