Slow process to clone with source control
jescan
Posts: 4 New member
Hello, I installed Source Control for Oracle and I am working with oracle database 11 xe on a azure vm with ubuntu 16, but I see that the process is very slow when I try to clone the github repository with my database, is this delay normal?
Tagged:
Comments
The performance in this scenario is going to be impacted by several things including the connection to both the Azure VM where the database resides and to where your source control system is located and the number of objects that are in the schema(s) you have added to the project.
Source Control for Oracle works in a similar way to SQL Source Control as described on this page https://documentation.red-gate.com/soc7/reference-information/how-sql-source-control-works-behind-the-scenes and so there are various actions going on when you set up the project including reading information from the database itself and also connecting to the repository.
If there are a large number of objects this also impacts the speed as the comparison process performance is largely related to the number of objects.
Kind regards,
Alex
Have you visited our Help Center?
Jesus
The tool uses various data dictionaries to get information it uses. It will try to use the dba_* version first, but if it doesn't have permission to that, then it will fall back and use the all_* version which, in addition to having to wait for the first to fail, also takes longer. It sounds like this may be what is happening.
The data dictionaries we use are listed on the bottom of this page https://documentation.red-gate.com/sco5/requirements/permissions-required-to-use-schema-compare-for-oracle and it also goes over the other permissions requirements.
Kind regards,
Alex
Have you visited our Help Center?