Re: Oracle MVS CPU Utilization Nightmare

From: Bill Hayden <dba0064_at_edwardjones.com>
Date: 1996/10/03
Message-ID: <32539601.3C7C_at_edwardjones.com>#1/1


Jim Ford wrote:
>
> We are running Oracle for MVS, 7.2.3, but use it strictly as a mechanism
> to access our Unix instances of Oracle. For example, a CICS program will
> connect to Oracle/MVS, which then uses SQL*Net (2.2.3) and IBM's version
> of TCP/IP for MVS (V3) to route the request to a remote instance of
> Oracle on our AIX boxes. There are no Oracle instances on MVS.
>
> While our applications work, we are paying a terribly heavy price for it
> in CPU consumption. We have a three processor Amdahl box, and Oracle,
> SQL*Net and TCP/IP are by far the largest consumers of CPU on it, to the
> point where little else is getting done. We are pumping a lot of

<<snip>>

Have you looked at Oracle client for MVS? That is what we are using for batch/CICS access to unix oracle instances. It took some tuning from the network standpoint, but it works and does not put much of a load on the mainframe.

-- 
THE PRECEDING REFLECTS THE VIEWS OF THE AUTHOR
AND NOT, NECESSARILY, THE VIEWS OF EDWARD JONES.
Received on Thu Oct 03 1996 - 00:00:00 CEST

Original text of this message