swhitmire
Reputable Poster
This weekend we moved from using ISAM files for Vertex to putting the Vertex data in a VERTEX schema in our jde database. All went well until we got a lot of users in, then we reached our maximum processes in Oracle (which had been working fine at 1500 for like four years). We doubled that to 3000, and hit the limit again this afternoon. Currently there are 954 connections among all our different JDE system users and 1933 connections for vertex, all coming from jde900 processes. Is anybody else using Vertex in Oracle? How many Vertex connections relative to your number of JDE connections do you normally see? Is there a reasonable limit, or is there some kind of bug that's keeping unused connections from being freed up?