Re: Perfomance degradation after upgrade 7.2->7.3.4. LIBRARY

In both cases the RBO is used, so execution plans for all SQL statements are the same (I verified).

Thanks,
Val.
To: Val Gamerman/Victoria Financial_at_VICTORIA FINANCIAL cc:

From:     "Scott Shafer" <scott.shafer_at_ildmail.com> @ NOTES NET
Date:     06/21/2000 10:44:43 PM GMT
Subject:  Re: Perfomance degradation after upgrade 7.2->7.3.4. LIBRARY
          CACHE

Did you delete statistics and then re-analyze your schema after the upgrade.
7.2 -> 7.3 included significant optimizer changes/enhancements, IIRC. --Scott Shafer
  San Antonio, TX

• Original Message ----- From: <Val_Gamerman/Victoria_Financial.VICTORIA_FINANCIAL_at_lnn.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, June 21, 2000 6:25 PM Subject: Perfomance degradation after upgrade 7.2->7.3.4. LIBRARY CACHE

>
>
>
> 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.
> Thanks,
> Val Gamerman.
>
>
> --
> Author:
> INET: Val_Gamerman/Victoria_Financial.VICTORIA_FINANCIAL_at_lnn.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Thu Jun 22 2000 - 09:03:06 CDT