As part of our unit test set-up we are dropping and recreating and oracle schema before each run. This process is currently a HUGE bottleneck on our build system. The issue appears to be dropping an oracle user before each run, depending on what else is hitting the server at the same time it can take over an hour just to drop the existing oracle user.
I've been looking into this issue for awhile and I found some documentation saying that dropping all the tables and objects from the schema before dropping the actual user account can increase the performance. This is working okay but it's still a big bottleneck.
I also doubt that this is simply a hardware issue because the server we are using is pretty damn powerful and should easily be able to handle a dozen users or so actively working on it.
I know this is rather vague but if anyone has any tips or suggestions it would be greatly appreciated.
Aucun commentaire:
Enregistrer un commentaire