Slowly refresh

Track changes to Oracle schemas in your existing version control system.

Slowly refresh

Postby chavdark » Tue Mar 18, 2014 3:08 pm

Hi, I've downloaded and tested the Source Control for Oracle v.2, but have some problems refreshing objects.
The refresh takes a very long time - may be 5 or more minutes. Is this normal behaviour? This makes it practicaly unusable. The changes I've made on database will apear after very long time.
I am using TFS.
Posts: 2
Joined: Tue Mar 18, 2014 3:01 pm

Postby chavdark » Thu Mar 20, 2014 9:32 am

Is seems that it is working much faster when I connect with SYS user.
Posts: 2
Joined: Tue Mar 18, 2014 3:01 pm

Postby eddie davis » Thu Mar 20, 2014 2:12 pm

Hi Chavdark,
thank you for your forum post and sorry that you have encountered a problem.

I am not aware of any specific performance problems. If you added a schema that is very complex, would expect Source Control for Oracle (SCO) to take a longer time to refresh compared to schema containing much fewer objects.

Also you need to take into account the workload of the Oracle server, TFS server, the machine running SCO, network bandwith.

There are no configuration settings within SCO that will speed up the actual refresh process.

Many Thanks
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
eddie davis
Posts: 1148
Joined: Wed Jun 14, 2006 2:47 pm
Location: Red Gate Software

Re: Slowly refresh

Postby armplinker » Mon Dec 01, 2014 5:21 pm

Perhaps disabling automatic refresh would be helpful. Once you are ready, use manual refresh. Right-click on the project on the Source Control Projects tab, uncheck refresh automatically, and then use the Refresh menu item. It would seem, however, that Source Control for Oracle ought to be able to tell exactly which objects have been locally modified and compare (only) those with the database. Am I missing something?
Posts: 15
Joined: Mon Jun 16, 2014 9:47 pm
Location: Massachusetts USA

Return to Source Control for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests