11-22-2016 01:06 AM
Customer asked us how they should setup their oracle server for the GMSC solution.
We need to have an idea of ram needed and if you have any advice focused on good performance (for the oracle part) it would be welcome.
The idea is to have 150 users at the same time on GeoMedia Smart client, the solution will not be used for huge data update most for the time data will be accessed in read only mode.
11-22-2016 02:39 AM
it's really hard to answer, it mostly depends on how you will publish the data. It might be you will have a very limited usage of the database if you set most of the feature as cached. I would say any general database cluster for such a user load would be sufficient.
11-22-2016 04:06 AM
I know customer will have only one physical Oracle server so no cluster. I have no idea of the needed RAM needed for an oracle instance in the parameter MEMORY_TARGET i guess sa for 150 users it is not so high maybe 5 Gb dedicated to the instance seems very confortable, i 'll also ask for a dedicated disk for the instance. In France we never manage those aspect it was always done and managed by integrator so after we never had feedback about the behaviour and metrics. Maybe someone can tell me if my "wild guess" seems reasonable or crazy?
11-22-2016 04:42 AM
it might be reasonable. Consider Oracle performances are really tied to the memory available for the process. If the RAM dedicated to process is not enough the DB will slow down considerably. You can check anyway the behavior while the system is running.
11-22-2016 04:45 AM
Yes thank you, i 'll tell customer that those parameters should change accordint to the db usage.
11-23-2016 01:15 AM
I am not sure about Oracle, but in one of our projects (Water/Sewer Utilities), we have an SQL Server Standard Edition that uses >15GB of memory (~15-16GB) for a maximum of 10 users (realistically 4-5 working at the same time).
We do however have a lot of features in the project (60 caching on demand features, 55 cached features). Also the users that are working are constantly changing the data for 15-20 features.
I hope this information helps.
11-23-2016 03:58 AM
Yes, we do have heavy workflows for editing (automatically setting the county/city based on where the point was added using geometry intersections, checking which user has the right to edit the geometries on multiple zones, other things like this) , but we do try and find the most performant-efficient solution and we do optimize our queries.