Re: Oracle/OpenVMS Performance Question
Date: Thu, 20 Oct 1994 18:05:42 GMT
Message-ID: <James.Lawrence.7.000D18BC_at_epamail.epa.gov>
In article <1994Oct10.142138.1_at_rhine.is.rice.edu> nmetro_at_rhine.is.rice.edu (Nick Metrowsky) writes:
>From: nmetro_at_rhine.is.rice.edu (Nick Metrowsky)
>Subject: Oracle/OpenVMS Performance Question
>Date: 10 Oct 94 14:21:38 CST
>Situation:
>We are experiencing slow response time and a very low transactions/second by
>our users. External to Oracle, things look and act very fine, but internal
>to Oracle and Banner, things run very slow. Some users report a 5 minute
>response time in performing a commit. I ran the DEC Performance
>Capacity Planner Software (V1.1) and it gives me user response time in
>double digits and transactions/second well below less than 1/second. One
>should expect the opposite results
Before I dug into all the facts you've provided, I'd run SQLDBA and see if you've got a lot of user's waiting on locks. With a 5 minute commit response time I suspect contention.
>We support a mix of interactive users and batch jobs. A recrurring batch
>jobs runs every 15 minutes, at priority 4. The interactive users and Oracle
>run at priority 4. The remaining batch jobs runs at priority 3. The batch
>jobs consist of payroll, accounts apayable and some large reporting jobs.
>All batch and interactive processing is run between the hours of 8:00 AM and
>5:00 PM. I have strongly recommended against doing this practice, but my
>warnings go unheeded. Because of our low CPU load, this seems like a
>contributing factor, but I do not think it is the only cause.
>Of course, this problem could be related to the way the application is
>written or to how the Oracle database is set up. I personally do not
>believe that OpenVMS, VAX, or the DEC products are functioning poorly.
>I will provide Performance Reports, upon request. The size of the reports
>exceed the 60 block limit for DSNlink.
>Any ideas would be most welcome. Thanks.
>--
>==============================================================================
>Nick Metrowsky |
>System Programmer | Internet: nmetro_at_rice.edu
>Rice University |
>P. O. Box 1892 | Phone: (713)285-5409 FAX: (713)527-6099
>Houston, Texas 77251-1892 |
>==============================================================================
Received on Thu Oct 20 1994 - 19:05:42 CET