After upgrading to Oracle 12C, GeoMedia connections are much slower.
Versions of GeoMedia prior to version 2016, build 10267, may exhibit a connection performance problem for Oracle 12C warehouse connections. GeoMedia had to modify the way SQL statements were submitted to take advantage of an Oracle 12C enhancement that changed the dictionary view for ALL_OBJECTS.
Changes in GeoMedia were implemented that should improve connection performance issue through the use of bind variables for certain SQL select statements. The changes were made in the GeoMedia versions listed below:
GeoMedia Connection Type |
GeoMedia Version Implemented |
Oracle Object Model Read-Only |
|
Oracle Object Model Read-Write |
|
Oracle Object LTT Read-Write |
GeoMedia also delivers an optional .sql script that may help improve GDOSYS metadata interactions with the GFEATURES view. The script is recommended only for Oracle 12C databases. Look for NewGFeaturesView.sql located in the C:\Program Files (x86)\Common Files\Intergraph\GeoMedia\Scripts folder.
Ensure that you are using GeoMedia 2016 build 10267 or higher. Consider running the NewGFeaturesView.sql provided with GeoMedia.
Other Considerations:
Ensure Oracle 12C installation is on the latest patches. If upgrading to Oracle 12C, install version 12.1.0.2.
Oracle 12.1.0.1
Oracle 12.1.0.2:
Statistics:
For both 11g and 12c, database statistics are very important and must be up to date. Set up Oracle jobs for the following:
Run Weekly during non-peak hours (run nightly if data changes frequently)
Run Occasionally
Run Rarely (after patches or other updates to the database instance)