Hello all,
I have exhausted all the things that I could find to try, Oracle Support
has not proven to be helpful so far either, so here is a question.
I have a new box (to become our production server soon) that I am testing
the upgrade of 7.2 to 7.3.4 on. I am using a benchmarking tool called
BenchMark. I have compiled a read-only benchmark that performs bunch of
select statements. The test starts with userload of 2 and runs for about
1.5 hours simulating concurrent users (up to 20).
When I run the benchmark against 7.2 database I get the throughput of ~90
tps (transactions per second) and response time of up tom 127 ms when
running under the load of 20 cocurrent users.
When I run the benchmark against 7.3.4 database I get the throughput of ~82
tps (transactions per second) and response time of up tom 155 ms when
running under the load of 20 cocurrent users.
The database is the same (I just upgraded the software), the box is the
same, the init.ora parameters are the same.
I ran utlbstat/utlestat under both I noticed the following differences
related to LATCHES:
NOWAIT_HIT_RATIO
7.3.4 7.2
LIBRARY CACHE 84.61% 99.9%
CACHE BUFFERS LRU 90.1% 100.0%
NOWAIT_HIT_RATIO
7.3.4 7.2
LIBRARY CACHE 86% 98%
I also noticed that number of BUFFER BUSY WAITS under 7.3.4 is twice as
high as under 7.2.
Platform: Netware 4.2
1 CPU
600 M of RAM
I tried bumping up the SHARED_POOL_SIZE from 45M to 50M and it did not make
any difference ...
Does anybody have any idea about what it might be ?
Any information, hints, things to try are welcome.
Received on Wed Jun 21 2000 - 17:16:24 CDT
